My guess is your using Access as a FrontEnd to the BackEnd MDB file.

Create a VB(6) FrontEnd - that way you wont get a LockFile.