References to backend table

E

Emma Aumack

I have successfully split my database! Whooo hooo!!! Do I now have to
update code in various procedures that creates tables because I don't want
the tables created in the front end I want them created in the backend. For
example: I have a table that I want imported to the backend. It was
imported into the database with the following code:

chkGTL = "C:\AS400\Check_Greater_Than_List.csv" 'Path for the
AS400 download

DoCmd.OpenQuery "Qry_flush_tbl_Greater_Than_List" 'Delete old
records from tbl_Greater_than_List

DoCmd.TransferText acImportDelim, "Check_Greater_than_List
Import Specification", "tbl_Greater_Than_List", chkGTL, False 'upload of
AS400 file

then run through some queries to get the formatting correct and then a new
table is created:

DoCmd.OpenQuery "Qry_Make_GTL_Contracts_Table"

The first two DoCmd.'s I believe are okay because they don't actually create
anything, just delete and replace records. But this last DoCmd.OpenQuery
actually makes a table. Is it better to just do a delete and replace again
here or can I have this query actually make the table in my backend?

thanks!!

End Sub
 
S

SteveM

Yes, you will have to specify the database or they will be created locally in
the FE.

Steve
 
E

Emma Aumack

Okay, I was going to ask how to do that but I figured it out myself. I just
need to modify the make table query in the front end to make the table in the
backend. Thanks for your help and not giving me too much information . . .
Now it's something I will never forget. . .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top