db locked and not accessible afterwards

[cynapattery]

Hi I have a problem with a cleint-Server accessdb that I created and works fine. But rarely (may be once in a week), I get a record lock file (normaly 1kb size) which is not the normal record lock taht appears when the system runs. This file does not get closed even if the db is closed. Also, I can delete it and I can access the db again. when this lock file exists, I cannot access the db.
any suggestions? does anybody already faced this problem?

 

[jkl0]

Open the lock file in notepad and it will list the computer(s) that has the DB open.

 

[cynapattery]

I got the computer where it is open, good tip!. But, my question is, why this lock file does not go away when the db is closed. NOT always, but rarely when the user gets some error. later on nobody can open the program. but, if I delete this 'lock' it works again.

 

[GinaWhipp]

This usually happens when there is a Permissions issues. I would suggest checking everyone's permission to the folder that holds the back end.

 

[cynapattery]

I dot think this is a permisssion issue(not sure though) since it happend also to me. also only this lock file can be deleted with out any problem. the normal lock file that produced automatically when some one open the software cannot be deleted. is this really a new issue? or is it due to some errors I made during programming. I am also not so profi! just started with vb 3 months ago..

 

[GinaWhipp]

The only thing that immediately comes to mind is you are opening a Recordset via code and not closing it.