Make table query in split database

[honeypot3]

Hi there

I have a number of make table queries which I need to run over a split database. At the moment when the queries run they do replace the table in the backend but store the new version in the frontend. Is there anyway I can get the make query to automatically store the newly made table directly into the backend instead without having to keep running database splitter each time the make table queries are run?

Thanks Sandra

 

[Remou]

How about In?
[tt]SELECT tblTable1.Field1 INTO tblTable2 In Tek-Tips.mdb
FROM tblTable1;[/tt]

 

[honeypot3]

Thanks Remou - found function in Make Table query drop down box - my brain is not functioning today!!