Frequent Database Crashes

A

AK

I have a database on a network drive which is accessed by multiple users.
Recently the database has started to crash with a backup created each time
there is an error. The form fields are replaced with question marks when an
error occurs. Please do send in your suggestions to rectify the problem.
 
L

Lynn Trapp

To start with, is your database split? If not you will want to do that as
soon as possible. Second, there is possibly some deep seeded corruption in
your database. I would recommend importing everything into a new database
and then running compact and repair to see if that solves your problem.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
T

Tony Toews

AK said:
I have a database on a network drive which is accessed by multiple users.
Recently the database has started to crash with a backup created each time
there is an error. The form fields are replaced with question marks when an
error occurs.
Click to expand...

Unfortunately there could be many causes for this. However I'd look
to see what changed recently. Was a new workstation added to the
network? A new server put in place? A service pack on the server?
Welding machine on the other side of the wall from a computer?
Laptop or PC on a wireless network?

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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
 
Top