When I have gone to compact an acces database I get an error message saying that a user is still using it, but all (2) applications had been closed (but one may not have closed properly). I have done this every day for the last 5 years without trouble !
How do I recover from this ?, do I just delete the lock file or how ?
suggestions will be very welcome !
thanks
4  4842 
When I've run into an ldb file that persists, I've always ended up having to shut down my machine and boot back up before I could delete the file.
BTW, shutting down a database incorrrectly can cause this problem, but more importantly, in a multi-user environment, it is considered to be a major cause of database corruption! Users should be warned of this fact!
Welcome to TheScripts!
Linq ;0)>
When I've run into an ldb file that persists, I've always ended up having to shut down my machine and boot back up before I could delete the file.
BTW, shutting down a database incorrrectly can cause this problem, but more importantly, in a multi-user environment, it is considered to be a major cause of database corruption! Users should be warned of this fact!
Welcome to TheScripts!
Linq ;0)>
thanks for the reply Linq
I did find this which I think I will try
Let us know how it works out!
Linq ;0)>
Let us know how it works out!
Linq ;0)>
got it sorted, didn't have to use the script, it managed to sort itself out and allowed me to compact and repair it, now all on song again :)
nice to have found this forum though, very useful when in times of need !
cheers
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Maurice |
last post by:
Folks
once again I look forward to your invaluable assistance.
When converting an Access 2002 mdb back to Access 1997 using the Access 2002
inbuilt tools I receive the following error message...
|
by: MS |
last post by:
Access 97 here.
I want a simple way to "lock" certain records on a form. Some records remain
"live" until all data is available which happens over time. When all the
fields are complete, I want...
|
by: Andre Laplume via AccessMonster.com |
last post by:
I have inherited a bunch of dbs which are are shared among a small group in
my dept. We typically use the dbs to write queries to extract data, usually
dumping it into Excel. Most dbs originated...
|
by: rdemyan via AccessMonster.com |
last post by:
With A2003, I'm having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here's the
scenario:
1) Computer #1 - A2003
2) Computer #2 -...
|
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button...
|
by: Beejer |
last post by:
I have a weird problem that I'm trying to solve but can't seem to find
a solution at this time. My Access database closes completely when the
"Else" of the VBA code is applicable.
I'm running...
|
by: ApexData |
last post by:
I know that somethimes when I make changes to the tables (like adding
new fields), these changes do not always appear in the field list. If
I remove the table name from the forms record source,...
|
by: mnjkahn via AccessMonster.com |
last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I
right click on the field name in Query Design View, and then click Build,
Access crashes before the Build window...
|
by: lgeastwood |
last post by:
I have a weird problem in Access 2007.
I've been working in A07 for about 2 weeks when this thing began
occurring.
I'm working in the VB Code Editor and set break points for event
procedures....
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| | |
