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

Posted on 2005-05-08
Last Modified: 2010-04-19
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?
Question by:JohnStahlarbeiter

    Author Comment

    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.

    Accepted Solution

    The question has been PAQ'd and the 500 points have been refunded.
    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    by Batuhan Cetin In this article I will be guiding through the process of removing a failed DC metadata from Active Directory (hereafter, AD) using the ntdsutil tool in a Windows Server 2003 environment. These steps are not necessary in a Win…
    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now