I work on a helpdesk and I have a user who has been adding records to a .mdb. They shut down the app, then later opened it again and now they get an error "Cannot update. Currently Locked". Nobody else is using the app it shouldn't be locked. The .ldb file seems to be the cause. Any suggestions on how to get things moving again??
5  3112  
I work on a helpdesk and I have a user who has been adding records to a .mdb. They shut down the app, then later opened it again and now they get an error "Cannot update. Currently Locked". Nobody else is using the app it shouldn't be locked. The .ldb file seems to be the cause. Any suggestions on how to get things moving again??
Occasionally the .ldb file does not release the lock db file (.ldb) after the database has been exited and closed. This can happen for a variety of reasons....one example cause is the inability to close all the tables during a compact and repair on close operation. If the .ldb file is the problem, here is what you do:
1. Close the Database (exit the application)..
2. See if there is an *.ldb file present with the same Base Name and in the same Directory as your Access Database *.mdb/mde
3.. If this file is present, Delete it.
4. Open the Database again and see if the same problem still exists.
5. If the .ldb file was the problem, try to determine what caused the lock file release failure (review how the application was shut down previously) so that you prevent future reoccurence.
An #1 action indicted for this type of problem is the shutting down of the database improperly, i.e simply turning off the PC without exiting the db first. I once worked at a place where an employee had to be threatened with termination of employment before she ever broke the habit!
Occasionally the .ldb file does not release the lock db file (.ldb) after the database has been exited and closed. This can happen for a variety of reasons....one example cause is the inability to close all the tables during a compact and repair on close operation. If the .ldb file is the problem, here is what you do:
1. Close the Database (exit the application)..
2. See if there is an *.ldb file present with the same Base Name and in the same Directory as your Access Database *.mdb/mde
3.. If this file is present, Delete it.
4. Open the Database again and see if the same problem still exists.
5. If the .ldb file was the problem, try to determine what caused the lock file release failure (review how the application was shut down previously) so that you prevent future reoccurence.
Thank you for the reply.
There was an *.ldb file in the same directory with the same Base Name and I tried to delete it but got the error "file in use". Previously, I had the use shut down the app so nobody was in the app that I know of. I am running XP Pro, is there a way to see who is using the file? The *.mdb and the *.ldb are located on a share drive for which I have adminstrative rights. Thank you.
An #1 action indicted for this type of problem is the shutting down of the database improperly, i.e simply turning off the PC without exiting the db first. I once worked at a place where an employee had to be threatened with termination of employment before she ever broke the habit!
Thank you for the reply. I'll be sure to verify that with the user.
Thank you for the reply.
There was an *.ldb file in the same directory with the same Base Name and I tried to delete it but got the error "file in use". Previously, I had the use shut down the app so nobody was in the app that I know of. I am running XP Pro, is there a way to see who is using the file? The *.mdb and the *.ldb are located on a share drive for which I have adminstrative rights. Thank you.
See response and links provided by Tony Toews in this link: http://www.thescripts.com/forum/thread193733.html Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: seansan |
last post by:
Hi there,
I have a large 6 MB database that is beeing accessed by another
acccess file executing as the front-end (both on windows shared
drive). I lock the records when a user is editing the item. Other
users cannot edit the item at the same time bcause the record is
locked.
My question. Is there a variable I can access that identfies the user
that is locking the record, so I can print this as an information
|
by: Aaron Smith |
last post by:
What is the best way to handle data in a multiple user environment? We
have forms that will allow users to add edit and delete data from a
table on SQL server. The data could be edited on multiple machines at
the same time. How do you keep the dataset constantly updated with
changes made to the data? I'm playing with just calling the fill method,
but it seems pretty unstable at times. Especially when deleting records,
they don't seem to...
|
by: epearce301 |
last post by:
Hi, I have table1 and table2, both are linked, and a query has been
run. I created forms that use both just the tables, and then another
one using just the query. All of the information is there, but I
cannot edit any records nor can I move to a new record on the forms.
I checked to see if they were locked, and they are not.
Please help!
|
by: =?Utf-8?B?bWlrZWc=?= |
last post by:
Hi,
I am building a small Help Desk application for my company and need to be
able to edit "open" help desk issues. I use a simple datagrid to display
each issue (6 per page) , with an Edit button. There are a lot of fields
across, and my Network Admins would like a way of editing/updating each
issue seperately in a a vertical form. I need a way of clicking on the edit
button ,bringing up a form with the record, editng the fields, and...
|
by: Nestor01 |
last post by:
Is there a way to determine whether another record has been pulled up in a form in edit mode PRIOR to allowing that record to be used/opened in the same form? I've described a similar question about record locking, but am still trying to solve and wondered whether there was a way to access the record's attributes/properties that would tell me it's locked for editing before someone else tries to open it.
| | |
by: EManning |
last post by:
Using A2003. I've got an FE with a main form with a subform. The
subform is a mixture of bound and unbound fields. The main form is
unbound and all it has on it is a combobox to choose a patient's
name. Once the patient is chosen, the subform refreshes to show that
patient's data. The problem I'm having is that 2 or more users could
select the same patient and attempt to update the subform. If user #2
tries to update a bound field...
|
by: EManning |
last post by:
I posted a question on 5/5/08 asking how to trap an error caused by
multiple users trying to access the same patient. Here's what I
posted:
"Using A2003. I've got an FE with a main form with a subform. The
subform is a mixture of bound and unbound fields. The main form is
unbound and all it has on it is a combobox to choose a patient's
name. Once the patient is chosen, the subform refreshes to show that
patient's data. The problem...
|
by: sam12 |
last post by:
I have an application where all the fields on the form are locked preventing editing of the information(Through a function lockUnklockfrm) until an edit button on the form is clicked or NEW RECORD EVENT occurs which then unlocks all the fields for editing. However, most users come in and move to a field and forget that all fields are locked and that they try to edit the data. Is there any event code that can be placed on a field when the user...
|
by: emanning |
last post by:
Using Access 2003 and using a form that's mostly bound. I need a way
to tell if user-1 is on the record when user-2 tries to open the same
record, w/o waiting for the user-1 to save the record first. The only
way I can think of is by adding a flag to the record and setting it to
true when user-1 opens the record. If user-2 tries to open it, the
flag is checked for true, then a message would be displayed to them
that user-1 is on the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
