MS ACCESS 2000 database

  • Thread starter Thread starter Mangesh Chitnis
  • Start date Start date
M

Mangesh Chitnis

We are using MS Access(2000) as a database(single mdb
file) for an application.

When mutiple users access this files it hangs and crashes
the application.

Getting the following Error during such situation
"The basis of data "dbfile.mdb"(access database file) has
repaired a basic file of data.You or another user maybe
left microsoft access in an unexpected way while a basis
of data microsoft access was opened. Try repairing the
database."

Whenever the above problem occurs we stop all the
connections in the server and repair the database. we
don't know who(machine/user) crashes the application.

This problem occurs randomly.

Please advice.
 
See Tony Toews page for much information regarding corruption and crashes:

http://www.granite.ab.ca/accsmstr.htm

Is the app split into frontend (forms/reports etc) and backend (tables)?Does
each user have their own copy of the frontend? Have you verified the problem
isn't the result of faulty network hardware?
 
Back
Top