B
BillD
I have a call listing subform on a form I use to look up and edit records of
individuals. The calls/notes subform has a date field. If I sort on the date
field then the database, most times, will let me close, but I cannot reopen.
The .ldb lock file does not close and cannot be deleted as the MSAccess
process is still running. Error I think says the database is still in use so
can't be opened. It also says sharing violation if I try to rename. "The
source or destination file may be in use". I have been able to use an unlock
program to unlock the .ldb file. Then I can close the MSAccess process and
reopen the database.
What can I do to fix this? I do not usally sort this field. I just tried it
to see if it would sort. Now I need to fix as a customer may have same
problem.
individuals. The calls/notes subform has a date field. If I sort on the date
field then the database, most times, will let me close, but I cannot reopen.
The .ldb lock file does not close and cannot be deleted as the MSAccess
process is still running. Error I think says the database is still in use so
can't be opened. It also says sharing violation if I try to rename. "The
source or destination file may be in use". I have been able to use an unlock
program to unlock the .ldb file. Then I can close the MSAccess process and
reopen the database.
What can I do to fix this? I do not usally sort this field. I just tried it
to see if it would sort. Now I need to fix as a customer may have same
problem.