|
Home > Archive > MS Access Multiuser > April 2005 > 'database already in use' error with access 2.0
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
'database already in use' error with access 2.0
|
|
| PintelonP 2005-04-26, 9:24 am |
| 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
| |
| Larry Linson 2005-04-26, 8:25 pm |
| 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
"PintelonP" <p.pintelo@tiscali.be> wrote in message
news:I8rbe.146393$Uh3.97578@biebel.telenet-ops.be...
> 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
>
>
|
|
|
|
|