sql - question about frequency of updating access -

I have a table in the Access database

This access database is used on a regular basis, Originally from 9 to 5

Someone else has a copy of this exact table. Sometimes records are added, sometimes deleted, and sometimes data is updated within the record.

I need to update the Access database table with either the offsite table every hour. What is the best algorithm for updating the data? Have approximately 5000 records

Will it lock the table for a few seconds every hour?

The impression is that this question will be given to your previous questions. Together:

1. To find out the presence of a new file "listener" and do something with it
2. Some extensions in a folder
3. To delete file data in your database, doCmd.TransferText
4. Delete records in imported, updated, table based on an imported set of records
< / Ol>

can be We give you time to give a more detailed picture of it.

Tony asked whether both sites are on the same van Wide Area Network). You said that they are on Windows, somewhere you said that you are using a network, please tell us about the network.

I am still unsure whether you need a one-way or two-way data exchange. You talked about importing changes from a remote table to the local master table. Do you need to perform the same type of operation on a remote site: Import changes made to the table on the master site?

What should we do about the issue raised by James, can local and remote users ever edit the same record? If they can, how will you solve the conflict? Similarly, what if a remote user updates a record and a local user removes his copy of that record?

Based on what you have said so far, it seems like a real challenge for access, challenging the record changes (5000 per hour) more challenging. I like that Kiwin has suggested though your challenge will be more complicated, because you also need an account for record deletion on both sites.

It seems that you may have to make something that uses the 'access' replication feature, you should see if you can modify your design to take advantage of replication . I can not help you there, and unfortunately you frustrate David Fenton, which is a major authority on jet repetition.