Can't access repaired database from remote machine

[heraldis]

We had a corrupted database yesterday, which has now been repaired using Access.

However we can no longer access the database from other machines. I get the error:
-----------
Actinic failed to open the database DSN=ActinicCatalog75.
The database may be corrupt or the version may be newer than expected.
This prevents Actinic working.

The error was:

The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
Driver's SQLSetConnectAttr failed
------------

All is fine on the machine with the database on (and where it was repaired).

Thoughts please?

Jalea

[Jan]

You need to copy the database to another location (copy not rename, so that you have two), then delete the original one (or rename this time, so you have a backup) and then rename the new copy to ActinicCatalog.mdb. It should work then.

You can also fix this using the database repair tools in my spellchecker program, more details and a free trial for this program here :

http://www.mole-end.biz/acatalog/Catalog_Health_Check.html

Regards,

[heraldis]

well blow me backwards with a chocolate fan. It works! Why does that work?

Thankyou!:) :D

Shame Actinic support didn't know about that one..