Database Locked By User

[sha7jpm]

I have a simple data entry database,

but the users are encountering the error relating to 'this database is locked by admin "PC number".

this appears when one user is in design mode, and therefore access 2000 does not let others access the db.

but no one is in design mode. all users are using forms derived from a query.. it is driving me and the users mad!

does anyone have any pointers?

grey hair beckons!

thanks
John

 

[AncientOne]

Has anyone opened the db with the "exclusive " option ticked?
Or has anyone got a rogue ldb file left over from a crashed session?

 

[sha7jpm]

hi

there was an old ldb file in the directory.. did not think of that affecting it.. so have deleted that..

fingers crossed this solves it..

many thanks for the help.

john.

 

[mr moe]

if any of the users exit the application abnormaly this will cause the problem. This is one bad thing about ms access.

 

[sha7jpm]

the end of that!

well dont really know what it was in the end..

I remade the database as a basic table, 1 query and a 1 form, no modules or extra background code at all, and the problem still remained.

I took off the autonumber, added it in again, and the dbase stopped producing the error...

cannot understand that one! but it works now...

cheers for all the help and advice..

john.