Tables :: SQL Creates Linked Table In Front End

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;"

then I fill in the table using

Code:
DoCmd.RunSQL "INSERT INTO TransNMTbl SELECT * FROM TransTbl;"

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.