'database already in use' error with access 2.0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PintelonP - 26 Apr 2005 14:14 GMT

Dear,
A problem with soft from older versions of access and WIN.
Anyone can remember it?
I run an old version of a database application written in Access (2.0).
Every thing went fine unther W95. After moving to 98 SE, I always receive a
'Couldn'd use [dbname] and "database already in use'/couldn't close
[dbname].. error when I quit the database (and data where altered or forms
wher printed). This sometimes corrupts the database and I often have to
repair it. This error should be an error due to record locking by another
user but there is only me on that PC.
Changing the 'exclusif only' box doesn't solves the problem.
Anyone has a suggestion?
Thanks for your advise. (I cannot convert the database to a more recent
version since it would be to much work and I m the only user)
Patrick

Reply to this Message

Larry Linson - 26 Apr 2005 21:06 GMT

This could be due to a recordset not closed, or a form open and invisible...
Access 2.0 did not automatically delete the .LDB file when the last user
closed the database. It is quite possible for "the other user" to be
yourself in many situations... a form open on the same data that you are
trying to use in another form, for example.

If it were my code (where I often have a lot of VBA and DAO code), I'd look
for objects opened but not closed or objects instantiated and not later set
to "Nothing", as a first step.

Larry Linson
Microsoft Access MVP

> Dear,
> A problem with soft from older versions of access and WIN.
[quoted text clipped - 11 lines]
> version since it would be to much work and I m the only user)
> Patrick

Reply to this Message