Unrecognized database format

M

Martin

Users on a database I've developed regularly get the error
message "3343: unrecognized database format" followed by
the path to the file. This only happens when there are
two or more sharing the database and can happen on loading
it or while they are working in the form. Has anyone got
any suggestions?
 
K

Kevin3NF

Is this a split database with the BE on a server and the FE on the client
workstations?
 
T

Tony Toews

Martin said:
Users on a database I've developed regularly get the error
message "3343: unrecognized database format" followed by
the path to the file. This only happens when there are
two or more sharing the database and can happen on loading
it or while they are working in the form.

As Kevin suggest splitting the MDB is the first thing to be done if
the MDB isn't split.

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.

Otherwise see the Corruptions FAQ at my website.

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
 

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