Access is "already opened exclusively..."

[Kay]

Hi All,

I have a VB6 app to do some data import from a SQL server to an Access
database, somehow, the app crash and after that I can't open the access db
anymore, when I open it always say the db "is already opened exclusively by
user 'Admin' on machine 'xxx'.

The machine name is the one I used to import the data. Obviously there's no
more connect to the Access DB, I tried to restart the machine (win xp)
however still no luck, tried to delete the .ldb (or even the .mdb) file but
I'm not allowed.

The access file is saved on a server so instead of restarting it, is there
other way to fix this problem?

Thanks in advance!

Kay

 

[Guest]

Kay,

When you say, "Obviously there's no more connect to the Access DB" you may
be incorrect. If the app you are running to do the import is opening another
instance of the access database and not having it to be displayed (made
visible), it could be, and actually sound like the database is still open
even though the original app has crashed. You will need to check the code
that is doing the import to see if this is the case. If you find that it is
opening an instance of an Access database, just put error checking code in
place to close the new instance of the database before exiting if there is an
error.

 

[Kay]

Thanks Mr B I think you're right, there may be an instance "left over", but
I don't have much idear how to kill that instance.... Any suggestion??

THanks!

Kay