Report and Set Recordset

[JpSkyPilot]

Hi:

I have built a program in Access where the currentdb does not hold a specific table and this table is not appended to the database. I have connected to the access database that holds the table and want to run a report on that table. I can't use Me.recordsource = vehsql because I get an error that the vehsql cannot find the table (it is not attached and is not in this database). If I try to "Set me.recordset = vehdb.openrecordset(vehsql)" I get an error saying that this is not available except in ADP.

Is there a way I can run the report on a table that is not in the DB and is not appended to it...but the program is only connected to the db where it is located?

Thanks
JP

 

[MarkK]

You can write SQL that directly references a table in a different database file...

SELECT * FROM tSomeTable IN 'C:\Databases\YourDB.mdb'

 

[JpSkyPilot]

Thank you...I'll try this.

JP