unexpected state

[Guest]

can anyone help me avoid corruption of data base that results in error
message "Access in unexpectedstat etc." Have been using for 1 year on 2003
and 5 years prior on 97 with absolutely no problems. this was a bolt from
the blue? Gremlins?? Have 7 potential users. Small data base but busy.

 

[Albert D. Kallal]

Is your database split? It should be.....

First, read the following article on a split database.
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Further, does EACH workstation get a mde?...again, they should.....

After reading the above..then you can read additional issues on corruption
here:
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Guest]

In addition to Albert's advice, you may find these articles helpful:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

and

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

Make sure that each user's PC has the latest service packs for:

1.) The operating system
2.) The version of Office and
3.) The Jet database engine

There are links in the first article shown above that will assist you in
checking these issues out.

In addition, you should verify that each user's PC has the latest version of
the Microsoft Data Access Components (MDAC) files installed:

http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e
-a9e0-3a1afbd5922e&displaylang=en



Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Long Live Aaron Kempf]

uh Access MDB isn't reliable enough for that many users

you shoudl move to SQL Server

 

[Tom Wickerqueer]

how to keep a database in top working condition?

USE A REAL DATABASE!!@@!!