I have a old time clock program based on Foxpro database. It is working fine in headquarter building. Right now, we opened a second building which need employees to punch in using the same system and database.
I set up site to site VPN and maped the time clock folder locally. I can run the program and it shows the log in interface. However, when I input my employee ID and click "enter" it gives me error messages as below, and if I click "OK" on the error message box, it gives me the following error: "cannot update the cursor" . I guess it maybe the table is locked by the process running on the HQ. And I tried to exit the program on the HQ computer, the error still exists.
What can I do? I appreciate any help.