maketable query and non-local database

[Graham Reid]

Greetings all,

I have a split database with a number of maketable queries.
Up to now, these have been creating the associated table in the local
database
but now I want them to create the table in a specified destination database
(this may vary).

Rather than hand-editing each query, how do I change the destination
database of each query programatically?

My first though was to update the "Destination Database" property, as
displayed in the Query Properties popup.
However, I can't seem to locate where Access stores much of the information
displayed in this popup.

Analyzing the SQL property seems to show that the SELECT..IN..INTO is always
on the first line (the second being the FROM clause).
So, if I remove any present "INTO '...'" text from the end of the first line
and
append the desired destination, would work?

I'd rather use a more elegant method, but if this works, so be it.

Suggestions welcome.

Regards, Graham

[pietlinden]

You should be able to use something like this:

SELECT MAIN.Id, MAIN.Name, MAIN.Publisher
FROM MAIN In "C:\Documents and
Settings\user\Desktop\Orange\RawImport1.mdb"
WHERE (((MAIN.Name) Like "C*") AND ((MAIN.Publisher) Is Not Null));

Oh hell, I'm so stupid. How about just linking to a new database (or
updating it) and then you can just query the linked tables....
otherwise, you'll have to edit all your SQL statements the hard way...
very ugly.