C
Cathy
I am running a VBA module to access database tables and update other tables.
Occasionally, when I try to run the program again, I get a message indicating
that the database has been placed in a state from which it cannot be opened
or locked. Why is this happening? I am closing all recordsets and
connections in the program. The only way to get around it appears to be to
wait for an hour or two and try again. This is very frustrating!! I imagine
it is something I'm not doing in the program but it appears all connections
are being closed properlyl.
ANy ideas would be appreciated
Occasionally, when I try to run the program again, I get a message indicating
that the database has been placed in a state from which it cannot be opened
or locked. Why is this happening? I am closing all recordsets and
connections in the program. The only way to get around it appears to be to
wait for an hour or two and try again. This is very frustrating!! I imagine
it is something I'm not doing in the program but it appears all connections
are being closed properlyl.
ANy ideas would be appreciated