Rats! - "select...into" Replaced Linked Table

Hello folks,

I am looking over a mdb that I recently took over and found a problem.

There is a query that does a "select...into" a table, which obviously replaces the original table with the new records from the select statement.

Ok, but... The table is supposed to remain a linked table. The query currently replaces the linked table with a local table viewable only by the locally running mdb.

QUESTION: Is there a way to set up a select into statement to replace a linked table with another linked table?

I found:

dim mydb as database
set mydb=currentdb
mydb.execute ("INSERT INTO Table1( [Field1], Field2, [Field3] )
SELECT [Field1], Field2, [Field3] FROM Tablename IN 'c:foldernamedatabasename.mdb")

Which could do the trick, but I would prefer not to hardcode the path to the network data.mdb. Maybe I could query the path of the table and use that into the above... Ideas? Just now thought of that...

I figured I would ask before I rewrote the query to merely update with new records and then delete old... or delete all then update/insert with all new...

Ideas?

Thanks!