Hello Experts,
I have a frontend and a backend database. As usual i keep the tables in the backend. Now I have some tables which need to be emptied and then refilled. I empty the table using the code
then I fill in the table using
The code runs fine. The problem is that the linked table is not used and the sql statement creates another TransNMTbl table in the front end and puts the data there. Bu I need the table to be in backend. Help please.
I have a frontend and a backend database. As usual i keep the tables in the backend. Now I have some tables which need to be emptied and then refilled. I empty the table using the code
Code:
DoCmd.RunSQL "DELETE * FROM TransNMTbl;"
Code:
DoCmd.RunSQL "INSERT INTO TransNMTbl SELECT * FROM TransTbl;"
Last edited: