• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 739
  • Last Modified:

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.  error message 1 error message 2
0
Jason Yu
Asked:
Jason Yu
1 Solution
 
jrbbldrCommented:
First, I cannot say about other people using any other browser, but I cannot read the error messages that your screen shots are attempting to show.

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

0
 
Olaf DoschkeSoftware DeveloperCommented:
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.
0
 
Jason YuAuthor Commented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Olaf DoschkeSoftware DeveloperCommented:
Create a user group, grant access to that group and only move users into it that should have access.

Bye, Olaf.
0
 
Jason YuAuthor Commented:
good
0
 
ee_autoCommented:
Question PAQ'd and stored in the solution database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now