The File <dbname> isn't an MS Access file or is corrupted

[Dustin]

I have a database that contains data used for testing
other software products. There is a main form that allows
users to select scenarios they want to test and a subform
shows the data fields used for testing. Users can then
copy and paste the data out and enter new data in to be
used as inputs for other tests.

There is no workgroup created for this database users just
open the file and start testing. Record locking is
enabled on the form to keep users from updating the same
record at the same time. However there have been multiple
instances when multiple people are in the database that
the get the following error:

"The File <dbname> isn't an MS Access file or is corrupted"

Does anyone know what is causing this and what the remedy
may be? There is not a linked or embedded image on the
form or in the DB so I know it isn't that.

Thanks

Dustin

 

[Tony Toews]

I have a database that contains data used for testing
other software products. There is a main form that allows
users to select scenarios they want to test and a subform
shows the data fields used for testing. Users can then
copy and paste the data out and enter new data in to be
used as inputs for other tests.

There is no workgroup created for this database users just
open the file and start testing. Record locking is
enabled on the form to keep users from updating the same
record at the same time. However there have been multiple
instances when multiple people are in the database that
the get the following error:

"The File <dbname> isn't an MS Access file or is corrupted"

Does anyone know what is causing this and what the remedy
may be? There is not a linked or embedded image on the
form or in the DB so I know it isn't that.

Chances are the problem is because the MDB hasn't been 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..

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