Report and Set Recordset

JpSkyPilot

Registered User.
Local time
Today, 14:03
Joined
Feb 23, 2012
Messages
20
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
 
You can write SQL that directly references a table in a different database file...
Code:
SELECT * FROM tSomeTable IN 'C:\Databases\YourDB.mdb'
 
Thank you...I'll try this.

JP
 

Users who are viewing this thread

Back
Top Bottom