Different Unrecognized Database Format

[SDDavid]

I have found many references to this issue but none so far
have addressed my problem.

Access 2000 database gives "Unrecognized Database Format"
error only when being used by multiple users on network.

Notes:
Database was developed as 2000 format.
ALL users are using Access 2000 SP1.
No problem opening and using as single user app on network.
I have tried importing all elements into a new blank DB.
Can recover using 'compact and repair'.

Thank you in advance.

 

[Tony Toews]

I have found many references to this issue but none so far
have addressed my problem.

Access 2000 database gives "Unrecognized Database Format"
error only when being used by multiple users on network.

Notes:
Database was developed as 2000 format.
ALL users are using Access 2000 SP1.
No problem opening and using as single user app on network.
I have tried importing all elements into a new blank DB.
Can recover using 'compact and repair'.

Have you split the MDB into a FE/BE and giving each user their own
copy of the FE? This is a significant problem in A2000 and newer.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless.. It also supports
Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm