473,574 Members | 2,556 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

error "database engine could not lock table because it is already in use by other"

19 New Member
Hey Guys,

I have an access database with a few tables and forms. I was trying to add a new combo box to one of my forms and to do so i needed to add the referenced data to my reference data table. simple or so I thought, but while attempting to do so I got the following error ""database engine could not lock table because it is already in use by other " . I am currently the only user with access to this database so i'm at a lost as to how it is possible that the database is locked by another user.

Please can anyone assist.
Aug 13 '07 #1
12 49372
matthooper
37 New Member
Did you have the table open?
Aug 13 '07 #2
ewarts
19 New Member
While trying to add the combo box to the form? No I don't think so.
Aug 13 '07 #3
matthooper
37 New Member
and are you using code to add to the list or are you using the horible access control thingie...
Aug 13 '07 #4
ewarts
19 New Member
No codes just the access standard procedures.
Aug 13 '07 #5
missinglinq
3,532 Recognized Expert Specialist
Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

http://www.thescripts.com/forum/thread559246.html

Thank you and Welcome to TheScripts!!

Linq ;0)>
Aug 13 '07 #6
Scott Price
1,384 Recognized Expert Top Contributor
Hey Guys,

I have an access database with a few tables and forms. I was trying to add a new combo box to one of my forms and to do so i needed to add the referenced data to my reference data table. simple or so I thought, but while attempting to do so I got the following error ""database engine could not lock table because it is already in use by other " . I am currently the only user with access to this database so i'm at a lost as to how it is possible that the database is locked by another user.

Please can anyone assist.
First of all, check to make sure that there is no .ldb file residing in the same folder as your database that remains there after you have closed the db, if there is, delete the .ldb file. (this is an access generated file that logs which users are accessing which parts of the database, to lock out/avoid conflicts with one user accessing the same record as another at the same time.)

I had a similar problem happen to me rather intermittently. I tracked it through a combination of deductive reasoning and intuition :-) to closing the db after having failed to compile any code changes in the VBA editor window.

From that I learned quickly to Compile, Save, Check Compile status, Save again before leaving the VBA editor window.

Another suggestion is to make sure you Compact-Repair and backup your database on a regular basis, at least once a day when you finish for the evening.

If you are interested in how to prevent corrupted databases, this is a very good page dedicated to just that: http://allenbrowne.com/ser-25.html

Just for reference purposes, here is Allen's Recovering corrupted databases page: http://allenbrowne.com/ser-47.html

Hope this helps you with your problem.

Regards,
Scott
Aug 14 '07 #7
ewarts
19 New Member
First of all, check to make sure that there is no .ldb file residing in the same folder as your database that remains there after you have closed the db, if there is, delete the .ldb file. (this is an access generated file that logs which users are accessing which parts of the database, to lock out/avoid conflicts with one user accessing the same record as another at the same time.)

I had a similar problem happen to me rather intermittently. I tracked it through a combination of deductive reasoning and intuition :-) to closing the db after having failed to compile any code changes in the VBA editor window.

From that I learned quickly to Compile, Save, Check Compile status, Save again before leaving the VBA editor window.

Another suggestion is to make sure you Compact-Repair and backup your database on a regular basis, at least once a day when you finish for the evening.

If you are interested in how to prevent corrupted databases, this is a very good page dedicated to just that: http://allenbrowne.com/ser-25.html

Just for reference purposes, here is Allen's Recovering corrupted databases page: http://allenbrowne.com/ser-47.html

Hope this helps you with your problem.

Regards,
Scott

Scott,

I think what's happening here is, when the firm runs a daily back while the file is being updated then that backup file will still be open even though I may close the original. I'm hoping this is the case, can you or anyone confirm this?
Aug 16 '07 #8
Scott Price
1,384 Recognized Expert Top Contributor
Scott,

I think what's happening here is, when the firm runs a daily back while the file is being updated then that backup file will still be open even though I may close the original. I'm hoping this is the case, can you or anyone confirm this?
Can't confirm it without seeing the whole setup physically before my very own eyes, no...

Why would they be running the daily backup during a time that someone else is working on the db? Is this a 24 hour operation, where they don't have a downtime? If it IS 24 hour, is it mission-critical so the db can't be 'shut down for maintenance' for the 15 minutes or so that it would take to do the Compact/Repair & Backup?

You might want to look at a better daily maintenance program schedule if at all possible, to avoid this very kind of conflict... (If this is in fact the problem that you are having!)

Regards,
Scott
Aug 16 '07 #9
ewarts
19 New Member
Can't confirm it without seeing the whole setup physically before my very own eyes, no...

Why would they be running the daily backup during a time that someone else is working on the db? Is this a 24 hour operation, where they don't have a downtime? If it IS 24 hour, is it mission-critical so the db can't be 'shut down for maintenance' for the 15 minutes or so that it would take to do the Compact/Repair & Backup?

You might want to look at a better daily maintenance program schedule if at all possible, to avoid this very kind of conflict... (If this is in fact the problem that you are having!)

Regards,
Scott

They backup on a nightly basis however I may have left the db running over night.
Aug 16 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
1880
by: dcrespo | last post by:
Hi all... Here is my infrastructure design of a "distributed" system: - Many (30-50) hosts connected via VPN to a server. - Each host manages a system that receives local data (stored in a local database), and has to be sent to the server, so the rest of the hosts can "see" this data. What I want? I want to have a...
0
4413
by: Dejan M. | last post by:
Please can you help me with this problem: In the next form, when I Add new person who is not registered in the base I had the massage: The Microsoft Jet database engine cannot find a record in the table 'CLAN' with key matching field(s) JMBG. The question is: How to add data for the unregistered visitors in the next fields: JMBG (unique...
4
2304
by: (Pete Cresswell) | last post by:
I would argue that it is not. JET is a desktop DB engine. Sybase is a database Oracle is a database DB2 is a database. VB 6 is a front-end development tool. PowerBuilder is a front-end development tool. MS Access is a front end devlopment tool.
0
4347
by: Colleyville Alan | last post by:
My app is giving me this error. Run-time error 3211: The database engine could not lock table 'Sorted_Template' because it is already in use by another person or process. When I run the app the first time through, it runs fine. I get this when I run a make-table query that tries to write out the table called "Sorted_Template". I tried...
4
1574
by: cw | last post by:
(new to access / databases) I have just installed MS Access 2000 on an XP Sp2 based PC. Each time I try to create a new database or project I get a series of error messages. The main one is "The MS Jet database engine cannot find the input table or query 'Hisago1105_sub'. Make sure it exists and that its name is spelled correctly.
1
1924
by: wxqun | last post by:
Our company is now trying to make a "standard" of creating a base view for each user table. This initiative is suggested as a good practice by a data modeling consultant who is helping us to build DW logical/physical model. He pointed out that the work and risk of making a database change will be reduced by using the "base view". Since...
10
3941
by: cyber0ne | last post by:
I'm having a bit of trouble adding records to a local .DB file (using a Paradox connection string). I checked the file permissions, and for testing purposes set Everyone to Full access. But it seems that I can add one and only one record to the table, any other attempts to insert a record generate the error: "Operation Must Use An...
1
2658
by: 1978fx | last post by:
I'm trying to EXPORT the results of a query to a CSV file. I've been doing this, using different queries, for WEEKS, with no problems. This file always thinks that the resulting export file is already opened, but the file resides on my hard drive, and I get the error even if I delete the file and start from scratch. I'm not doing this via...
2
6796
by: dowlingm815 | last post by:
I am attempting to create a table with an index. however, i am receiving an error code "3371: Cannot find table or constraint" as soon as it reads the "create index" statement. The code is as follows" thank you in advance for any guidance. strSeqNumber_TEMP = " " strIndexOrg_TEMP = "0" strFund_TEMP = " " strAccountCode_TEMP = "0"
0
7738
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...
0
8257
jinu1996
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...
1
7828
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...
0
8113
tracyyun
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...
0
6476
agi2029
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...
1
5634
isladogs
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...
0
3765
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1358
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1076
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.