ms access ldb files not deleted

[shakeel]

hi
we run web questionnaires from our windows dedicated server. the data is stored on MS Access databases. the problem we are experiencing is that after a user has done a questionnaire and exited, the ldb file for the database does not get deleted.
some ldb files have been on the server for over a month.
we have checked to see if any one is still in the questionnaire and have found it to be idle for a long period of time.
i read in another forum that the user needs delete permissions in order for the ldb file to be deleted.
can someone please let me know if this is safe to do and which user needs the delete permission?

thanks in advance

shakeel

[Rock]

Hello Shakeel,

LDB file has the special function to manage the lock information about the access database and along with of each user who opens the shared database i.e. the name of the computers/users who are currently accessing the database in the multi-user environment of the Microsoft Jet database engine.. The information written in the LDB file is used by MS Access to tell which records are locked in the database and who is responsible for that. You can open it through notepad to check who are using it.

Can you make sure that nobody is using the database after deleting the LDB file from the server? As each time when the access database is first opened, a file with the extension .ldb is created with the same name as that of the database. This file gets deleted as soon as the last user closes the database. Hence there would be some connection left open which creates the .LDB file, I'd recommend checking the code/scripts for any connection being left open after the script execution.

Read/Write permissions for the web user, ie: IUSR_machine-name are needed on the MDB file, which can be granted either from the control panel or you can request granting them through a support ticket. I'd request you to send an email to our support dept for granting safe/secure read/write permissions on the folder containing the access database. You can find more info here regarding exact permissions as well: Introduction to .ldb files

[shakeel]

Thanks rock you have been of great help

[Rock]

You are most welcome, Shakeel

Ohh & I almost forgot !

Thanks for registering at EUKHost - Community Forums! We are glad you have chosen to be a part of our community and we hope you enjoy your stay.

All the best,

[DPS Computing]

Shakeel .