Make Table Query

[crhodus]

I have a database named NewUpdate.mdb. I have another database named MainDatabase.mdb. Almost all the tables in NewUpdate.mdb are linked tables that are in the MainDatabase.mdb file.

I've written a simple make-table query in NewUpdate.mdb that makes a backup of a table that is located in the MainDatabase.mdb file. (See code below.)

SELECT tblProviderRate.* INTO tblProviderRateSave
FROM tblProviderRate;

The only problem is that this new table is created in the NewUpdate.mdb file. I need the query to be stored in the NewUpdate.mdb file and the "new" table to be created/stored in the MainDatabase.mdb file.

This sound simple enough, but I'm drawing a blank as to what I need to do in order for this to occur. Can someone tell me what I'm leaving out??

Thanks,
CRhodus

 

[WayneRyan]

CRhodus,

I think something like this, but my Access Help isn't alive now ... go figure

SELECT tblProviderRate.* 
INTO tblProviderRateSave In 'C:\SomeFile.mdb'
FROM tblProviderRate;

Wayne

 

[crhodus]

Thanks! That did it.

Crhodus