Solved

Can't save records in Foxpro database

Posted on 2010-09-22
7
659 Views
Last Modified: 2012-05-10
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
Comment
Question by:Jason Yu
7 Comments
 
LVL 12

Expert Comment

by:jrbbldr
ID: 33740218
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
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 33741402
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
 

Author Comment

by:Jason Yu
ID: 33746616
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 33747316
Create a user group, grant access to that group and only move users into it that should have access.

Bye, Olaf.
0
 

Author Comment

by:Jason Yu
ID: 34177393
good
0
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 36017003
Question PAQ'd and stored in the solution database.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now