Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3165
  • Last Modified:

Microsoft Access Record-Locking Information

I've searched and searched for informative information on Microsoft Access Record-Locking system. I'm been working on a small database where I monitor and store inventory data through microsoft access. However, Today i tried to access my data and it appeared to be locked through the Access record locking system. It shows that I have 2,114 KB of data still there so hopefully it isn't lost? Could someone please tell me how to unlock this record locking system thus accessing my data once again. Thanks so much.

Todd
0
Lawrence-Nelson
Asked:
Lawrence-Nelson
1 Solution
 
arbertCommented:
Look for a file with an LDB extension in the same directory as your database.  Try and delete it and then see if you can open the database--this is where the "locking" information is stored.

Brett
0
 
Lawrence-NelsonAuthor Commented:
No results were found in the Database directory. Any other suggestions?
0
 
syntnxCommented:
Lawrence,

Have you tried compacting and repairing the dbase. Either by selecting it under "Tools\Database Utilities\Compact and Repair or by using a utility like one of these:

Access 97 http://www.utteraccess.com/candace/candace/backup/autobkup.zip

OR

Access 2000
http://www.candace-tripp.com/download/autobkup2k.zip

Hope this helps

syntnx
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Lawrence-NelsonAuthor Commented:
Syntnx;

I ran the compacting and repairing utility. And it said it was repaired sucessfully, However i am still not able to access my tables. Is there a setting that is prohibiting me from viewing my tables in the database? Is there something I can change?

Thanks so much for your advice for this database is very important to our company.

Respectfully

Todd Arms
Lawrence-Nelson, LLC
0
 
Lawrence-NelsonAuthor Commented:
Syntnx;

I ran the compacting and repairing utility. And it said it was repaired sucessfully, However i am still not able to access my tables. Is there a setting that is prohibiting me from viewing my tables in the database? Is there something I can change?

Thanks so much for your advice for this database is very important to our company.

Respectfully

Todd Arms
Lawrence-Nelson, LLC
0
 
syntnxCommented:
Lawence,

Check the settings in the tools, options, advancd tabs. Specifically, record locking on the right of that screen.


I believe the defaults usually are "no locks". Also open database using record-level locking is unchecked.

0
 
Route81Commented:
Before experimenting any further, create a new (empty) database and (if possible) import all tables, queries, etc... that are in your original application.

Try if you have access to your stuff through the new database.
If you do, adjust your startup-settings and delete the old one or try to figure out what went wrong with the original application.
0
 
Lawrence-NelsonAuthor Commented:
Thanks Syntnx.
0
 
syntnxCommented:
np , best of luck!
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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