-
I have encountered a problem with the ldb file, one particular user seems to corrupt the file locking records and keeping a permenant connection open even when everyone is out of the database.
Any ideas what is causing this one user to be the problem, he tells me he logs out of the program correctly.
VB6,SP3,Access 2000
-
razamadaz
He tells you he logs out correctly. :rolleyes:
I would make sure he does.
We had a similar problem where some users had a problem on thier pc and just CTRL+ALT+DELETE. This locked the database up.
There is one way of releasing the locks by using the following
Code:
DBEngine.Idle dbFreeLocks
DBEngine.Idle dbRefreshCache
This will release any locks
Don't know if this is much help to you but I suppose every little helps.