unexpected state

L

LowTechy

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.
 
T

Tom Wickerath

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
__________________________________________
 
L

Long Live Aaron Kempf

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

you shoudl move to SQL Server
 
Top