Make Table Query To Back End DataBase 1

[Fage]

Hey everyone,

I recently split a database in the hopes that it would solve the run time errors i was getting when two people had it open at once. And it did, however, the front end runs some make table queries and i want those tables to be on the back end. Is there anything i can do so they get put there and not on the front end?

thanks,
-Fage

 

[Remou]

You can use IN.

SELECT A.Field1 INTO New IN 'c:\docs\db2.mdb'
FROM A;

http://lessthandot.com

 

[Fage]

thanks Remou i think taht is going to work perfect