Database Locked By Another User

I have a problem with a database. There are 4 users who tries to work with it at the same time, but they have problems allt the time. It often happens that they got an error "The db is locked by another user" and then they canīt do anything.
Please any idea why? Or a solution?

View Replies


Message: Database Locked By User, Cannot Access Database - Version: 2002 (10.0) XP

Mulitple users are using a basic database complete with switchboard, forms, tables, queries, etc.
Sometime one user will have the database open all day and it will somehow lock the database so if other users try a open / access the database they will recieve a message that states on opne" database has been locked by DEL-1263" and they cannot open or access the database. I tried creating a workgroup with usernames to access to see if it would not lock the database and allow multiple user access without locking, but it's not working.
How do I do this so he database does not become locked by one user ???

View Replies View Related

Database Locked By User

I have a 2000/2003 format database used only for reporting.

It has linked tables to an SQL Server database.

It automatically opens a form with two buttons on it (no data) and hides the database window and the regular menu, replacing it with my own toolbar.

The default open mode for the database is "Shared."
The default record locking for the database is "No Locks"
On the opening form, the record locking is set to "no locks."

Yesterday, no problem for two of us to share it.

However, when I open it on my computer (not to edit - to use. I simply open it - not in exclusive mode.), and then another person opens it, they get the message that says "the database has been placed in a state by "Admin" on machine (my machine) that is locked and will not be able to be opened." (not verbatim, but close.)

When the other person opens it first and then I try to open it, I get a message that I don't have exclusive access and will not be able to save changes. I have to hit okay about 6 times, but then it opens.

Some users at off-site locations are having problems sharing - some are not.

Any ideas?

View Replies View Related

Shared Database Locked With One User - Version: 2003 (11.0)

Suddenly, a few months ago, all my shared applications on our network began locking out all others when one person has the application open. I have checked all the obvious (network privileges, shared is checked, no record locks on database or forms/queries).

My applications ARE divded and, at least in this case, size doesn't seem to matter. (HA! HA!)

But here's the REAL catch....if a 2nd (3rd, 4th) user opens it from our base Intranet rather than from a shortcut or the folder directly, it works! How crazy is that?!?!

I am not a network person. But if anyone out there has expertise and knows something more on this, I will pass on to my network guys. I have tried searching MS website with not much luck.

P.S. Because of military requirements, I can't place a F/E on each user's system. They all access one F/E off the network.

I you need more info, please don't hesitate to ask.

View Replies View Related

Multiple User Receiving Record Locked


I have a database we use to enter new account numbers and several other atribbutes about the account and it is split into a FE/BE with the BE in a shared folder. I have the open database using record-level locking checked but it seems to me that the database is opening up with page-level locking. Multiple users will receive a message that the current record is locked and I am sure that they are all not updating the same record. Does anybody have any idea's of what I can do? If nothing else I am going to have to recreate my form as an unbound form and see how that goes.

View Replies View Related

Another Multiple User Locked Records Issue... - Version: 2003 (11.0)

Hi all,

I should specify that the database is 2k, but the version everyone uses is 03.

It's stored on a 2003 Server. About 14 users are entering data via 21 bound forms to the same table. The reason for that many forms is that each one has different data preloaded to speed up the process. I have a PK setup in an autonumber ID field. The name of the ID field is Card ID.

As of yesterday the users started to receive the "Could not update; currently locked message" unless one of them completes the record they are working on. It's very frustrating. I have no security on the database and all users have the same type of AD login accounts.

I just finished reading some recent threads discussing the issue, but I can't figured what could be wrong. I read a suggestion to use:

Private Sub Form_Load() = Your_ID_Function
DoCmd.RunCommand acCmdSaveRecord
End Sub

Not sure how to change the line to apply in my case. Is there any other ways I can fix this?

Thank you,


View Replies View Related

3186 Error (locked By 'admin') On A Single-user Application - Version: 2.0 (not 2000)

I have a single-user VB6 application that employs an Access database that was created by the Visual Data Manager. Nobody else uses this machine. It is not networked. As such, I did not build in any locking logic into the application.

While entering data today I got a runtime error 3186 "couldn't save; currently locked by user 'admin' on machine..." I've had no luck removing these phantom page locks. I've never signed on as 'admin' in my life on this computer. It sounds like some housekeeping routine has gone awry.

I am looking for advice on how to clear these locks, and would be very grateful for assistance.

View Replies View Related

Locked Database

i have this database with tables i can't access, so i had to import the data into a new database , given the size of the new database JoeCruse (form this board) pointed out that it could be that the front end is separated form the back end. and i can't find the front end anywhere

i want to press F11 and see the tables and so forth open up when i launch the original db. how do i go about doing that.

View Replies View Related

Database Locked Up NEED HELP

I have a database that I password protected. Somehow, in the process of applying the password, the file became corrupted and now I am getting the following error message:

"This database is in an unexpected stat; Microsoft Office Access can't open it.

This database has been converted from a prior version of Microsoft Office Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state."

Does anyone know what this error is and how I can retrieve my data?? I have tried to import the files into a new database, convert the database into a different version and compact and repair. Nothing has worked. I have looked into recovery tools and two of them do get me into the database and let me see some of the data, however, the programs are holding my information hostage until I purchase the software which is running around $300.00. Any ideas???

View Replies View Related

Locked Access Database

I have a MS Access 97 database that seems to be locked. I wish to update it but I cannot open it as a regular file. When it is opened, there is no way to edit the database or access any of the controls that are usually present. The tool bars are even different.

Any idea?


View Replies View Related

Database Locked Error

OK, I have a database that works great when used on 1 computer. Basically, a friend of mine has a dj show, and he wants an electronic request system. So, I came up with this database, which works great on one computer. I am attaching the database.

So, the problem is, the database is on the dj computer, and then there is another computer on the network that will be setup for accepting requests. When I have the database running on one computer, when you try to open it on the other, it gives me a locked database error. Obviously the requests need to make it from one computer to the other. I'm pretty sure I didn't have it open exclusive. Any ideas...... I'm having a brain fart today, and I've not had much sleep.

View Replies View Related

Locked Out Of My Access Database

I am completely locked out of my Access Database!

Basically, I have 3 forms which have all got the properties set to DISALLOW right clicking on them to prevent users accessing the design of the form, they all have code behind them so that they cover the entire screen and block ALL menus/shortcuts apart from those available on the form and I have set up a command button on each form which is password protected to ONLY allow Admins to access the design/backend of the form/database when they enter a valid password.

However, I was playing around with the settings of all these forms and have inadvertantly locked myself out, the last thing I remember doing was setting up a "Password" form to collect the Administrator password which had code attached to allow access to the database design. This was working fine until I tried "tweaking" it and now whenever I input the CORRECT password, I get the error message;-

"Error 2585: This action can't be carried out while processing a Form or Report event"

If I enter an INCORRECT password, I get the standard "Login Failed-Please try again" form that I have set up.

The "Password" form doesn't have an override/Cancel (I wanted to make it REALLY secure) it means that although I can use the database fine for entering/editing information/data within the database when it first opens, as soon as I want to make changes to the design and try to log in with "Admin" privellages using my custom made "Password" form, it then pops up with the password screen and goes no further.

I do have a backup of this database BEFORE I set up the "Password" security to collect the "Admin" Password but I can't remember the code I used and although I can work it out again, it will take me a LONG time to work it out again. So I was wondering if any of you might have some ides or a workaround I could try to gain back "Admin" rights to my database.

Does this makes sense? As stated I do have a backup so if all else fails I'm going to have to try to remember how I got it working in the first place BEFORE I cocked it up but if any of you could save me the trouble that would be very much appreciated!

Thank you very much


View Replies View Related

Database Locked And Won't Open

When I try to open a single table database I get the following error message:

'The Microsoft Jet Database Engine stopped the process because you and anotheruser are attempting to change the same data at the same time'.

Despite re-booting the computer it still is locked - any ideas

View Replies View Related

Compiled Multi-user Database Throwing Error To One User - Version: 2003 (11.0)

Hi all,

I have a problem with a database that is used by a number of people. I can't seem to fix it though, was wondering if you could help me with the brainstorming.

The database in question is a multi user mde file that is split. All users go into the same front-end through shortcuts on their desktops. One user who has read-only can no longer run the reports. When a command button is clicked, an error appears saying "The OpenReport action was cancelled". Other users are not having the problem and I cannot recreate it on my work station. I have tried refreshing the front-end, but it did not make a difference.
Some other things - the user primarily uses a laptop. When he used a desktop, he could run the reports. The local profile was deleted off the laptop. The database was open and run successfully once. When the database was closed and opened again, it no longer worked.

I am out of ideas. The only thing I can think of is that the folder security is not set up correctly. The read-only users do not have the permission to delete files so they cannot delete the .ldb file when they are finished using the database. Could this be the problem? I am trying to get this fixed, but I need approvals and am being pushed to the side. If this is the reason, then I can have more ammo to move this along.
Also - what are other problems that can occur with the ldb file being left open for long periods of time?

Thanks for the help

View Replies View Related

Access Database Locked / Time Out

Hi Folks!! - Iím new to ASP and need to produce display some data with access. The following code I have used works but when the data is refreshed, the browser reports - a unspecified error, if I wait a while and refresh the browser it works again! Refresh it again immediately it fails! Please Help!! - Below is The Code -

<title>Connect To Matrix!</title>

Dim objcn
Dim recrs

set objcn = server.createobject("ADODB.Connection")
' "DRIVER ={Microsoft Access Driver (*.mdb)}; DBQ=C:Matrix Builderparts.mdb"
objcn.Open "DSN=matrix"
objcn.CursorLocation = 3
set recrs = server.createobject("ADODB.recordset")

SQL = "Select * from Parts order by category, description" sql, objcn

response.write recrs.recordcount & " RecordCount <br>"
while recrs.eof = false
response.write (recrs("category")) & "&nbsp; &nbsp;" & (recrs("description")) & "<br>"


set recrs = nothing
set objcn = nothing

View Replies View Related

Server Dumped...Database Locked...What To Do?

I log into my server via remote connection from 3000 miles away. My database resides there.

If for what ever reason, I dump locally - the server does not recognize that I dumped - and thus keeps me logged in.

When I log back in, it logs me in as a second instance.

Here is the problem:

I was in access changing a form when I was dumped. (power went out). Now the server thinks I am still connected working on it. How do I shut down the service that has the DB locked - and delete the record-locking file that resides in the directory beside the database. (this record-locking file is the file that access creates whenever you start editing your database forms..etc...). I can't just delete that file - as access tells the server that it is still in use.

I am almost sure a reboot would rectify this issue - is there ANOTHER way to do this? (what is the service that is running that can be forced down?)

Thanks in advance,

Belchlord - way down South.

View Replies View Related

Locked Database - Version: 2003 (11.0)

All of a sudden I'm getting an error when I try click a button on my form.
It says the database has been put in a state and cant be opened or locked. I'm the only user of the database so how did I do this. More importantly, how do i fix the problem???

View Replies View Related

I Have Locked Myself From My Own Database. - Version: 2002 (10.0) XP


I was curious abou the many options in the startup window, the one you access through tools. I unselected everything and now when I open my database, I only see the menu form, I have lost the capability to edit my database. How do I undo this. Please help. Thank you.

View Replies View Related

Locked Out Of Database By Myself - Version: 2003 (11.0)

We had a multiple user database get corrupted today, so I got everyone out, but it still won't let me repair it. Looking at the record locking file, I am the only user in the database, but I don't have it open. If I try to open it, it tells me it needs to be repaired, and I click OK to repair it, but then I get an error that it is "opened exclusively by 'Admin' on" my machine. So basically, I can't repair it because it's holding on to my record locks.

Is there a quick way to get around this? I've tried deleting and emptying the record lock file, and also tried renaming the database, but it says it's in use.

View Replies View Related

Database (back-end) Not Locked - Version: 2003 (11.0)

I have a front-end msaccess application on my client and a back-end db on the server machine.

I have the same front-end application on other clients. When a user open the front-end application,

the back-end db isn't not locked. I not view on the back-end folder a .ldb file and I can delete or rename this back-end db even if is in use.

In this particular application it is necessary for me to check that the back-end db is used by one client at a time and I doesn't know whether to do.



Edited by: cubalibre on Wed Oct 25 16:53:30 EDT 2006.

View Replies View Related

Unlock Exclusively Locked Database - Version: 2002 (10.0) XP

Help! Somehow, my Access 2002 database got exclusively locked and now we can only open it Read Only. How do I unlock it/remove the exclusive lock? There is no .ldb file.

If it is not possible to remove the exclusive lock on the database, is there a way to delete the database so I can start over? I have a copy saved in another location as a back-up I could use to replace the exclusively locked database.

Thanks so much!

View Replies View Related

Database Is Occasionally Locked By Users. - Version: 2003 (11.0)

Hi all,

I have an access 2003 database in a multi-user environment. Occasionally when the database is opened by a user the database becomes locked for all other users. There seems to be no pattern as to which machine/user is locking the database. Is there a way that the database can be accidentally opened in exclusive mode or is there some type of error that would cause this to occur? Is there a way to prevent users from locking the database exclusively?


View Replies View Related

Relink If Broken From Within Locked Database - Version: 2000 (9.0)

Hello All,

I have a database that I will be splitting shortly and distributing. when I set up each workstation I will link the front end, to the back end. I want to know if there is a way to create a form or something so that I can relink the FE to the BE thru the locked up database, so I dont have to unlock it, go into the menus and relink the FE to the BE.

Basically, all I want is to push a button, a form comes up and I can link and/or relink up the FE to the BE.

any help would be appreciated.

thanks in advance..


View Replies View Related

Database Cannot Be Exclusively Locked , Network Drive - Version: 2002 (10.0) XP

Hello all, first thanks for taking the time out to read this and for any suggestions you can give me. I would consider myself somewhat of a beginer to the more advanced features of Microsoft Access . so hopefully this problem is not too complex.

Currently I have a Microsoft Access database which I've created and also created a few forms to go along with it, this database does not sit on my computer, but on a network drive that several individuals have access to. The problem started when I wanted to make a page.

After making all the initial markings to the page and being happy with it I proceded to click save as per instructed. When saving it to the network drive, I am given this error :

<b>A Link to this data access page could not be created because the database cannot be exclusively locked. </b>

To create the link layer , open the page by selecting 'Edit web page that already exists', and then save.


I am assuming that this is occuring because this database is on a network drive; however, I am not sure on where to go from here to get a solution. I have already looked at the microsft website for documentation in addition to the Access Help File; unfortunatly, neither one has proved to be of much use to me.

I am hoping that someone has encountered this unfortunate situation and can enlighten me on how to overcome this obstacle.

Thanks for any help that can be provided.


View Replies View Related

Split Database On Network Is Locked , Sugestions? - Version: 2000 (9.0)

I split our database ,put the tables back end on a shared drive and copied the front end to three computers to test it. two of the computers can access it after relinking the tables, but the third gives me a message that the database is opened exclusivly by another user. After many tries , I tried two more computers, still, same message. All front and backend is set to open shared record level locking. There is no .ldb file showing anywhere. Am I missing something? Also, How can I get around having to relink the front end with each installation. I have about 40 computers to put this on... Thanks for any help or ideas! Sure would get the pressure off! The database was designed in Access 2000 and is to be running on Access 2002 that has all the service packs.

View Replies View Related

Database Locked By Blah Blah - Version: 2003 (11.0)

I really need help. I have a very important database I was given just 2 hours to develop. It has to do with litigation. All I need to do is log phone calls. It's very simple, however there have been "Locked" issues since day 1. I am down to 1 table in the hopes I can fix the problem myself, but it hasn't worked. There are only about 9 people using the database. All they need to do is pick an Activity Type, and log any notes they may need to. The Activity Types comes from: tblActivityType. I have another table called tblSR that houses the ActivityTypeID and the ActivityNotes. Nothing else. I used the lookup wizard in the tblSR to link the tblActivityType so they can pick the Activity Type from a combo box. I created a query based off the tblSR that I then used the Form Wizard to create the form. I constantly get "Can't update record, database locked by blah blah" errors. I tried putting the tables in a linked database and the forms in another...I got the same errors....I tried using the table to create the form...same errors. I am at my wits end! HELP! How do I structure the database so that multiple people can add records to a database all at the same time!

I am very sad!


View Replies View Related

Database Locked Problem - Version: Any Version

I am setting up an access database with a linked SQL Server backend. I have just tested it with about 16 users accessing it at once. Unfortunately there was a recrurring problem in that the database was constantly being locked by other users (or being ' placed in a state').
Does anyone have any idea why this is happening and what I could do to minimise this?

Any help would be greatly appreciated

View Replies View Related

Users Locked Out Of A Database - Version: Any Version

My end users are frequently getting a message saying that the database has 'placed the database in a state' by a user and it causes everyone else to be locked out.
Does anyone know what causes this?
Any help would be appreciated

View Replies View Related

Locked Myself Out Oy My Database - Version: Any Version

Hi all

I was playing with my database and the startup options. I turned off all the menus to see what it would be like when it booted up. It was nice and everything, but now I can't get anything back. I can't load up the database window so I can't access forms or anything. I can't access the toolbar that gives me the start up options.

When you are all done laughing, can someone let me know how to get back into the startup options and return things to normal???



View Replies View Related

User-only Browsable Database

I was wondering if there was a way to view mdb file without the navigation pane and ribbon (for Access 2007). I know I've used an access database that someone else made and it was done in a kind of "user-only" style interface where all you saw was the forms and reports in a dialog box style. This kept the user from seeing any of the tables and queries and all the "under the hood" types of things.

Does anybody know how to do this?

View Replies View Related

Multi-User Database

I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. Iím thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options

Any help is appreciated! Thanks

View Replies View Related

Need Help On A Multi-user Database

Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.

I appreciate any help you can provide me on this!!

View Replies View Related

Multiple User Database

I searched around to have multiple users and the only thing I found on the topic was
the following:

On the Tools menu, click Options.
On the Advanced tab, under Default open mode, click Shared.

and its suppose to work (which it didn't since I'm posting)

I have a few tables and a few forms, and I need to be able to have 2 or 3 people on at any given time.

Thanks for any help or even looking @ my post

View Replies View Related

Copyrights 2005-15, All rights reserved