Printable View
I am writing in VB6 and using Crystal Reports. As soon as I display a report the access .mdb file is locked with an .ldb file in that directory. It will not clear the .ldb file. I have to delete it manually in order to run a compact and repair. ANY SUGGESTIONS?
CR holds a lock on your db when using the CR IDE. Close CR and perform a C&R then re-open CR.
I did close CR and the lock still remains. This is what is so confusing. The only way to get rid of the lock is to close the vb app and then open access by itself then close it. Confused.Quote:
Originally Posted by RobDog888
Ok, then in your VB project are you using the connection wizard or the ADO Data control?
The ado data control.
The data control itself also performs some locking.Quote:
Originally Posted by randy1227
If you removed the data control and did your connecting via code I believe this issue would be resolved.