Can't save records in Foxpro database
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.
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.
jrbbldr, the unreadable screenshots are just a new preview of EE, you can download and they are readable.
cendescendent, seeing the error helps little about what's going on in the background. If you can't post code there's only general advice.
First of all there are 2 similar errors in foxpro:
111
Cannot update the cursor "cursor", since it is read-only.
1157
Cannot update the file "file".
I would say it's rather error 111, truncated. A common reason for read-only cursors is, wen they're generated by SQL INTO CURSOR without a READWRITE clause. But if that's the reason you would always get that error, also in HQ.
You've got the form name and method name and line number in the error, if you have the code, copying that method here would help to see what's going on.
Even though the error persist when you exit the program in HQ, this could be a sign this program is locking the tables in some way. It could not be exclusively opening the dbfs thaough, then you'd not even be able to read data in a second instance of the application. I also assume it's not running in a single instance in HQ anyway, it's meant for usage of all employees and so is programmed for shared access, is that right?
If it's really meant as a single running instance all emplyoees use, then you should setup terminal server, remote desktop, citrix, whatever remote access to the HQ computer to let users outside the HQ use that same instance instead of installing the app outside HQ. VPN is a good basis for that already.
Bye, Olaf.
cendescendent, seeing the error helps little about what's going on in the background. If you can't post code there's only general advice.
First of all there are 2 similar errors in foxpro:
111
Cannot update the cursor "cursor", since it is read-only.
1157
Cannot update the file "file".
I would say it's rather error 111, truncated. A common reason for read-only cursors is, wen they're generated by SQL INTO CURSOR without a READWRITE clause. But if that's the reason you would always get that error, also in HQ.
You've got the form name and method name and line number in the error, if you have the code, copying that method here would help to see what's going on.
Even though the error persist when you exit the program in HQ, this could be a sign this program is locking the tables in some way. It could not be exclusively opening the dbfs thaough, then you'd not even be able to read data in a second instance of the application. I also assume it's not running in a single instance in HQ anyway, it's meant for usage of all employees and so is programmed for shared access, is that right?
If it's really meant as a single running instance all emplyoees use, then you should setup terminal server, remote desktop, citrix, whatever remote access to the HQ computer to let users outside the HQ use that same instance instead of installing the app outside HQ. VPN is a good basis for that already.
Bye, Olaf.
ASKER
Hi, guys, thank you for your quick responds. I got it solved yesterday afternoon. In fact, I need set the permission for that folder. formorly, it was read permission for everyone, and I change it to co-owner permission for "everyone" user. it then can write to the database just the same as in HQ.
I am very glad I got it solved on time.
BTW, if I don't want everyone can access this folder, what should I do then?
Thanks.
I am very glad I got it solved on time.
BTW, if I don't want everyone can access this folder, what should I do then?
Thanks.
Create a user group, grant access to that group and only move users into it that should have access.
Bye, Olaf.
Bye, Olaf.
ASKER
good
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Regardless, when you get one error message and then a 2nd one, there is a high likelihood that the 2nd error message is due to problems that were caused in the 1st error message.
So, for now, forget the 2nd error message and focus on the first one. When that one is resolved, then it is likely that the 2nd one will go away.
If others have the same problem in reading the error messages on your screen shots, it might be best to just post the 1st error message and then let us attempt to help you out.
Good Luck