Solved

unlocking database files

Posted on 2004-08-17
4
1,349 Views
Last Modified: 2006-11-17
Does any one know of a  way to automatically unlock all .mdb and .ldb files? I continue to have locking problems with the databases which require me to manually unlock files until the DB lets us in.  It would be nice if we could do this automatically. Let me know your thoughts.  Thanks!
0
Comment
Question by:soda0091
4 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 100 total points
ID: 11821967
well you can run a batch file

del c:\mydatadir\*.ldb /Q /F

but id' try to find out why your ldb's are hanging around in the first place...it's usually caused by someone exiting improperly

0
 

Author Comment

by:soda0091
ID: 11823223
Any other suggestions? I will try checking that out.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

746 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

13 Experts available now in Live!

Get 1:1 Help Now