Back End Won't Open

[chris01252]

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end.

I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any ideas on what has happened and how I can fix it?

 

[chris01252]

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end.

I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any ideas on what has happened and how I can fix it?

 

[chris01252]

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end.

I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any ideas on what has happened and how I can fix it?

 

[John_W]

There should both a .ldb file and a .mdb file.

 

[chris01252]

I am such a numpty!!!!

found the other file (it was hidden)

Cheers John

 

[Alc]

Double check that there isn't an MDB and an LDB file.

The LDB file gets created when the MDB is opened and - I'm sure someone will jump in to correct me, if I'm wrong - indicates that the MDB file is locked, for certain actions (e.g. changing a table's structure).

There should also be an LDB file in the folder with your front end, whenever someone is logged in.

 

[gemma-the-husky]

the ldb is a temporary file that consists of locking information and also holds details of logged in users. it should disappear when users logout but occasionally remains - but thats not a problem

 

[boblarson]

but occasionally remains - but thats not a problem

Most of the time that's correct, but it can cause a problem if you need to do something that requires exclusive mode and the ldb still is there telling Access that someone else has it open. Usually you can just delete it if you know that nobody is in the mdb file. But, there are times I've run into the problem (only had this on NOVELL) where the ldb file won't go away regardless. It took some system admin the use of a special kill command to get rid of it, since the normal kill wouldn't work. I still don't know exactly what he did, but I do know I couldn't make any design changes to the backend because Access thought it was still being used.

 

[battenberg]

try holding down 'left shift' when you click the icon to open it...

this will bypass any startup scripts you may have put in there which may hide it.

 

[rainman89]

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end.

I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any ideas on what has happened and how I can fix it?

LDB is a record locking file created when someone has the file open. thats not your backend.....

 

[gemma-the-husky]

ive seen that before bob

rebooting definitely clears it, but thats a but drastic for a server

i think you can sometimes find the lock on the ldb file in user management/sessions.shares or some such

 

[KeithG]

Also it someone Ctrl + Alt + Delete and ends Access the file .LDB file will hang.