broken database

[NAS]

Greetings,

Whenever either myself or another user attempts to open a database on our
shared server, they will sometimes be told that the database needs to be
repaired. I run compact and repair which fixes the issue, but this happens up
to 3 times in one day. Is there a reason this is happening so often and is
there a way to fix it? We are using Access 2003, on Windows XP.

 

[Gina Whipp]

NAS,

MAKE A BACK-UP NOW... if you are both sharing the same front end read
this...

http://allenbrowne.com/ser-01.html

http://www.members.shaw.ca/AlbertKallal/Articles/split/

and then just in case read...

because it could be the the begining of corruption...
http://www.granite.ab.ca/access/corruption/symptoms.htm. I would make a
back-up, make another back-up and then first try importing everything into a
new database. Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm. And after all
of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances
apply to you.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Jerry Whittle]

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

One thing comes to mind: Is the database split and do you have a Front End
on each user's PC or is it just one database file out on the server? The best
answer is split.

As far as what's causing it, I'm betting that there is something wrong with
your network like a bad cable, network card, switch, router, etc.

 

[NAS]

Gina,

Thank you for your quick response. Indeed we keep backups as standard so I
will give all these things a try.