how do i get an ldb file to go away so i can download or upload new mdb

[MG]

as in subject
thanks

 

[MG]

can't
access denied
this is on a remote server and cant close program using the file

same for local

i once heard of an asp script or someting that can be run that can force an
access db to close

 

[Rick B]

Have you gotten everyone out of the file?

You would have to build a function into your database to allow you to "kick"
people out. Since you don't have that in place, I'd suggest you personally
notify each user to get out of the file. If the ldb remains once everyone
is out, then someone with proper access would need to delete the ldb file.

If you take away everyone's access to that folder, then add it back, I think
it will also kick them out, but could corupt the file.

Rick B

 

[GraemeR]

Hi, the .ldb file is deleted automatically once all users have exited the
..mdb.

If .ldb is not deleting then look at user permissions on the folder.
If you can't replace a .mdb then either someone has it open or you don't
have permission on the folder.

HTH, Graeme.