Re: cannot access mdb file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

SteveS
Date: 04/19/04 

Date: Mon, 19 Apr 2004 03:09:33 -0800

Lee Taylor-Vaughan wrote:

> Help! (please)
>
> I am trying to open my .mdb file and i am getting the following error upon
> opening it:
>
> "the microsoft jet database engine stopped the process because you and
> another user are attempting to change the same data at the same time"
>
> after i click ok the datbase exits.
>
> i tried to compact/repair the database, but i get an 'excusive' needed
> error.
>
> I tried holding down the shift key when double clicking the mdb file --still
> get the same error.
>
> i tried creating a blank database and then importing the tables, i get the
> same error as above when i select the database.
>
> this file is on my lap top, there are no other people, or user accounts
> trying to open this file.
>
> does anyone have a solution, PLEASE.
>
> TIA
>
> Lee
>
>
>

Lee,

Whenever you open an Access database, a file with the same name as the
database and an extension of LDB will be opened automatically. This
new file keeps track of users and the objects that require some form of
locking in the database. When all users have exited gracefully from the
database, the LDB file is closed down and deleted. If users don't exit
gracefully, the LDB file is not deleted. The next time the MDB tries to
open, it sees the LDB and the MDB will not open.

Look in the directory that the MDB is in and see if there is a .LDB
file. If so, delete it and try and open your MDB.

HTH 

-- 
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came, I saw, I stuck around.)

Relevant Pages

  • RE: HELP: LDB LOCK FILE
    ... particularly when the database is being used by multiple users. ... mention whether or not you are sharing this database with anyone else. ... .mdb, a couple of things could be happening. ... > I am having lots of troubles with the ldb file, I open a database and after ...
    (microsoft.public.access.modulesdaovba)
  • Re: How can I check if an Access database is open?
    ... But if the target .mdb is terminated abnormally, the .ldb ... I thought of having the target mdb write the system date/time to an internal ... Look for the presence of a xxx.ldb file in the same folder as the database ...
    (microsoft.public.access.modulesdaovba)
  • Re: how do you do "if record doesnt exist create otherwise update" in one SQL statement?
    ... > Mike wrote: ... the server after that (even if it uses a different database). ... the .ldb and installed a backup of the .mdb; I was then able to access ...
    (microsoft.public.inetserver.asp.db)
  • Re: how do you do "if record doesnt exist create otherwise update" in one SQL statement?
    ... the server after that (even if it uses a different database). ... the .ldb and installed a backup of the .mdb; I was then able to access ... Then I tried moving the backup mdb to another ...
    (microsoft.public.inetserver.asp.db)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)