You could kick everyone out using a check for a maintenance file using timer (this is your only real choice if you need to capture a 'snapshot' at a specific time where all tables match - in other words lets say you have a parent table and it has 2 child tables and you must copy all the tables without any orphans. Then also check when app is launched and kick the user back out if the file exists. Once the maintenance file is deleted the app will let them back in. Or you could loop through all tables and keep checking to see if you can open the file exclusively and wait until you can before you copy it until all are copied. In that case you will have to ensure that your app has error checking to handle someone else having exclusive use of a table. Or you can create a table with the same structure and indices and scan the table and copy records as they are unlocked until all records are copied. You will have to have some type of log to verify all records are copied but it may never be accurate if users are constantly editing or adding records. You will have to now how many records at a specific time and go by that. The best solution is the first if you want an accurate snapshot of your files and data and need to ensure that you copy files without a portion of a record edited or possibly the related records edited between when you start copying and finish.


>Dear Experts
>
>Some dbf is using, I mean someone is entering or editing data in it.
>Is it possible to make a copy of such dbf that is beeing used?
>I want to make a routing with timer control to copy dbf folder but I am afriad this will not work if some dbf is used in this folder.
>
>Please Help