"couldn't lock file" error

[Yazster]

Hi everyone,

I was curious if anybody else receives this error. I'm currently using the DAO Data control to access an .MDB database. My program works fine, but occasionally the database is not accessible to anyone and users receive a "COULDN'T LOCK FILE" error.

I've noticed that every time this happens, the associated .LDB file is locked and cannot be deleted or moved. When the .LDB file is finally accessible (sometimes 1 or 2 days later), the database is fine.

Is this a common problem?

Thanks,
Yazster

 

[shepherd]

It sounds like there may be a bug in the way you're disinstantiating your connection to the database. The only time I've seen this is when an object isn't getting destroyed properly (if a client crashes, or terminates in an unforseen way).