Linked table behavour

[Robin S.]

I'm having an issue with a linked table.

Overall picture: Our internal database uses .dbf files. I am using
Access 2003 to update prices within the database using price lists
from our vendors.

Specific operation: I drop the "products.dbf" file into a specific
folder, and that file is linked in my .mdb file. I copy the
products.dbf file to create a backup using FileCopy in VBA (so I can
compare the two and make sure the price update worked). The backup is
called "productsBAK.dbf and is linked to the .mdb as well.

I run an UPDATE query on the products.dbf file, and then compare
products.dbf and productsBAK.dbf using a simple SELECT query.

Problem: Every time I run the UPDATE query on "products.dbf", it
updates the bloody "productsBAK.dbf" table as well, even though there
is *no* reference to "productsBAK.dbf" in the UPDATE query.

Indeed, even if I manually delete the "productsBAK.dbf" file, the link
still works in the .mdb file, even if I refresh the link in the linked
table manager.

My question: Where can I find an explination on using linked tables
correctly? None of my programming manuals have that type of
description and I can't even guess what my issue is.

Thanks for any suggestions, keywords or links.

Regards,

Robin

 

[Robin S.]

Problem: Every time I run the UPDATE query on "products.dbf", it
updates the bloody "productsBAK.dbf" table as well, even though there
is *no* reference to "productsBAK.dbf" in the UPDATE query.

Indeed, even if I manually delete the "productsBAK.dbf" file, the link
still works in the .mdb file, even if I refresh the link in the linked
table manager.

I worked around the issue by running a make table query to create a
backup within the mdb file. Doesn't really answer my question, but the
process works now.

Regards,

Robin