Delete The .Lck File In Access2003 in Multiuser Environment

[sumansengupta]

I created an access in access2003 , its being used in multiuser environment ..based on a particular value the database is
automatically closed and only i can change the value. Even after the database is closed the .ldb file exist .. Now I tried your code die.cfm from the following website http://evolt.org/node/3644 , not very sure how to use it , because with the .cfm extension its not getting executed , can you suggest how can i get it executed ?, Or should I create a false query within the database so that it throws the error , but then while running the query I have to login to the database that will create the lock file .. The os used is Win Xp and the file is placed on a common shared drive

[nico5038]

The die.cfm is a ColdFusion file and can't be executed from Access.
The fact that a .ldb file resides after the database closure is no real problem.
It's very small and will always be re-created when the database is started again and it's missing, else it's re-used.

When you have a locking problem, there are other things to consider.

Nic;o)

[sumansengupta]

The problem that I am facing is I can not make any changes to the design if the .lck file is there .. I can copy the main database to a different location and do the required changes , but after making the changes I will not be able to replace the original file as Its being used and locked by the .lck file , at the same time I cannot provide a new database name to the 70users who are using it !.

[nico5038]

The .ldb file can be deleted when no other users are using the database.
When the .ldb file can't be deleted in the explorer, then at least one user is still active..

The moment a user (or VBA code!) changes e.g. a form into design mode, the database will be locked exclusively for that user.

Did you already split the .mdb into a front-end and a back-end ?

Nic;o)

[sumansengupta]

Yes the ldb file can be there because of two reasons one as you mentioned when any user is logged in and 2nd when all users have logged out but the database was not closed properly , so the ldb file was not deleted automatically . Now in the same database I have got forms as Front end .