Microsoft Access OLE DB — Microsoft Access

Microsoft Access

This allows you to easily refer to other database tables and queries without the need to create a linked table.

The database can be specified by the use of the IN clause

SELECT *
  FROM tblTable 
    IN 'c:\source.mdb'

or by applying square brackets around the database path and prefixing the referenced table with it

SELECT *
  FROM [c:\source.mdb].tblTable