I have a querydef which pulls data from another MDB. So my query will pull some data from local MDB and some from external MDB. When I pass the external MDB path to a select query my query seems to be working fine. But I have pass the external MDB path as a paramter. Any one had any idea how can I pass the path as a paramter to IN clause of Select query.
Note: I can pass parameter to where clause but not IN clause.
Select * from table In "C:\Test\Access.MDB" Where col = Param
Select * from table In MDB_PATH Where col = Param
Thanks in Advance