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

Why could I get an "Unable to lock record" error msg?

I have a VB6 program in beta test running on Win 98 machines in a school lab. The program and Access 97 database reside on the lab Windows 2003 server.

Suddenly I'm getting "unable to lock record" messages when the splash screen should appear.  The splash screen checks license info in the database.  

However one Win 98 machine, the first to start the program, does not get the message -- It starts the program as it should.  No other user, except the administrator running on the  server, can run the program at the same time.  A regular user on the server cannot run at the same time as one of the clients.  User "administrator" with a password that works on the server can log into a client, but cannot successfully run the program if another client is running it.

The database is in a shared directory, everyone has read and write access.  The program is installed as sharable.  

I'm pretty sure this is a permissions problem.  Suggestions?
1 Solution
JohnStahlarbeiterAuthor Commented:
Yep, it was a permissions problem. The containing directory inherited read-only from it's parent, but needed read/write.  Also needed to pass read/write downward.

I'm asking that this question be closed.
The question has been PAQ'd and the 500 points have been refunded.
Community Support Moderator

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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