But possible:
pseudo code
... select IDNAME from in c:\miodb.mdb\table1 where ...
googling... but is possible to use external db in query?
-
- PlatinumLounger
- Posts: 4334
- Joined: 26 Apr 2010, 17:36
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: googling... but is possible to use external db in query?
You can use
... SELECT IDNAME FROM Table1 IN 'C:\miodb.mdb' WHERE ...
The path and filename of the external database must be enclosed in single quotes.
... SELECT IDNAME FROM Table1 IN 'C:\miodb.mdb' WHERE ...
The path and filename of the external database must be enclosed in single quotes.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4334
- Joined: 26 Apr 2010, 17:36