Import problem during working hour

[Timothy_HK]

Does anyone can tell me how to resolve my problem?

In order to keep the records updates within different offices, I have to update the modified records twice times a days by export and import during working hours. The problem is if someone accessing in specified record, this record can’t be updated and don’t know which record can’t be updated is well. And, we really don’t want to close the file when perform the importation because isn’t convenient and will disturb all users.

Thanks in advance.

[Genx]

The only way you can do this is to temporarily disable the file, you can not make any changes to the information within a record while another user is modifying any record, you can however minimise the time by invoking some sort of script which automatically shuts the file down for a minute, runs an export all to this location, import all from this location script and then get the file to automatically open again with minimal disruption to the user(s)...

Edited September 29, 2005 by Guest