Access Database Corruption

[Greg Y]

Recently I have beem having problems with an Access
database continuously getting corrupted. The database
sits on a share drive and has only 4 tables. Two of
these tables receive data from two seperate multi-user
databases. Until recently everything has been working
fine. But now we are getting a "The
database 'F:\RMDB.mdb' needs to be repaired or isn't a
database file." message, and the repair option doesn't
work.

We have experienced different problems with other files
that sit on this drive but I don't know if the two are
related. Is there something I should have set up
differently for a multi-user environment?

Does anyone have any advice?

 

[Arvin Meyer]

If there is anything that interupt the smooth flow of packets between the
database front-end and the database tables, there is a chance of corruption.
It sounds like your drive may not be writing packets correctly.

In a multi-user environment, the data tables need to be in a database on the
server, and the users need to access that data from database front-ends
(forms, queries, reports, code, etc.) located on their workstations. Any
interruption caused by a bad NIC (network card), or a user who simply turns
of a machine without backing out and closing down can cause corruption. I
would first suspect a bad NIC, unless you've recently hired a new employee.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Pierre du Parte]

In a multi-user environment, the data tables need to be in a database on the
server, and the users need to access that data from database front-ends
(forms, queries, reports, code, etc.) located on their workstations. Any
interruption caused by a bad NIC (network card), or a user who simply turns
of a machine without backing out and closing down can cause corruption. I
would first suspect a bad NIC, unless you've recently hired a new employee.

Second that- experience has taught me check the NIC first. I've also had
a bad display card wreak havoc with an mdb file once

Check out http://www.granite.ab.ca/access/corruptmdbs.htm



--
,-._|\ Pierre du Parte
/ Oz \ Worrigee NSW OZ
\_,--._/ R1100S
v "Ride it like you stole it!

http://www.finalfiler.com
++++++++++++++++++++++++++++++
Everyday in every way it becomes
more and more obvious that the
World is run by educated idiots
living in the alternative reality
created by statistics.