Unrecognized database format

J

Joy

Hi,
Please excuse the cross post as I originally posted this in "multi-user" but
have not had a response so I'm trying this section.

I developed a multi-user database in Access 2000 (OS is Win 2000). The db
is split with the back-end tables on the server and all users have a copy of
their own front-end. Most of the VBA code is written in DAO. It's been
working fine, then a couple of months ago the following error began to pop
up sporadically. "Unrecognized database format '\\ Path \ back-end.mdb'.
The user clicks OK and the error message goes away and it works fine. It
usually happens when the db has been open in the background for a while then
when the user goes to open a recordset they get the message. The error
always refers to the back-end and the DB administrator said all Win and
Access updates have been installed.

Does anyone have any idea? Any help is appreciated.

By the way, all copies of the front-end are mde files. Could this make a
difference?
Thank you.
Joy
 
J

John Vinson

Most of the VBA code is written in DAO. It's been
working fine, then a couple of months ago the following error began to pop
up sporadically. "Unrecognized database format '\\ Path \ back-end.mdb'.
...
Does anyone have any idea? Any help is appreciated.

Sounds like some corruption in the backend. Have you used Tools...
Database Utilities... Compact and Repair Database on the backend?
Check out Tony Toews' corruption FAQ:

http://www.granite.ab.ca/access/corruptmdbs.htm
By the way, all copies of the front-end are mde files. Could this make a
difference?

That's preferable, actually. Obviously you need to have a copy of the
frontend in .mdb format *somewhere* if you're ever going to do any
design changes, though!

John W. Vinson[MVP]
 
J

Joy

Hi John, Thanks for replying.
Yes, the backend has been compacted. I have checked out Tony's FAQ but will
do so again in case I've missed something.

Re the mde files, there are masters on the administrator's pc and on a
backup CD.
Thanks again.
Joy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top