Database Corruption

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have a multi-user application that executes on a runtime on a file server.
I didn’t split the database by “front-end†(forms) and “back end†(data).
When there is no corruption, the database runs smoothly for days. On
occasions, the database gets corrupted thereby needing a manual “compact and
repair†process.


The Error Message is:
"The database “\\Land\Copy (3) of Property.mdb“ needs to be repaired or
isn’t a database file. You or another user may have unexpectedly quit
Microsoft Office Access while a Microsoft Office Access database was open. Do
you want Microsoft Office Access to attempt to repair the database?"


I created a program, within the database, to monitor users’ login and
logout. This captures all users’ activities including “abnormal exits†(date
and time). There doesn’t seem to be any pattern of users exiting abnormally
that would cause the corruptions. The database (“mdbâ€) gets corrupted even
when there are no abnormal user exits.

What could possibly cause the corruption?
 
Fred said:
I have a multi-user application that executes on a runtime on a file server.
I didn’t split the database by “front-end” (forms) and “back end” (data).
Click to expand...

Chris is correct. In your case the first thing to do is split the MDB
and give each user their own copy of the FE.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.
I created a program, within the database, to monitor users’ login and
logout. This captures all users’ activities including “abnormal exits” (date
and time). There doesn’t seem to be any pattern of users exiting abnormally
that would cause the corruptions. The database (“mdb”) gets corrupted even
when there are no abnormal user exits.
Click to expand...

Isn't that interesting. I've done the same in the past and it was
quite obvious, with the exception of power failures, which system
caused corruptions. In one case it was a Citrix server part of a
load balancing set. The IT department then setup the app so it
stayed on one particular server and no more problems.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
I didn't split the database by "front-end" (forms) and "back end" (data).
You've already got people telling you this is the cause of corruption. Me
too.
This captures all users' activities including "abnormal exits" ...
Click to expand...
OK, I'm Curious. How exactly do you capture "Abnormal exits"? The only way
I've found to identify them is by what did *not* get captured. I have a log
much like you describe but I can only identify abnormal exits by locating
Logins that don't have a corresponding Logout (i.e., the user had to have
used Task Manager or Power button to exit).
 
You've already got people telling you this is the cause of corruption. Me
too.


OK, I'm Curious. How exactly do you capture "Abnormal exits"? The only way
I've found to identify them is by what did *not* get captured.  I have alog
much like you describe but I can only identify abnormal exits by locating
Logins that don't have a corresponding Logout (i.e., the user had to have
used Task Manager or Power button to exit).

--
HTH,
George









- Show quoted text -
Click to expand...

Hi,

Seems that the mdb files after split are damaged or something. If
necessary, I think you can try a utility called Advanced Access Repair
to repair your Access MDB file. It works rather well for my corrupt
Access MDB files. Its web address is http://www.datanumen.com/aar/

Alan
 
Alan said:
On Apr 24, 1:20 am, "George Nicholson" <[email protected]>
wrote:
Click to expand...

Please look at the dates of the messages which you are spamming.
Seems that the mdb files after split are damaged or something. If
necessary, I think you can try a utility called Advanced Access Repair
to repair your Access MDB file. It works rather well for my corrupt
Access MDB files. Its web address is http://www.datanumen.com/aar/
Click to expand...

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Possible causes of database corruption is virus attack, improper shutdown,
disk failure, unexpectedly quiting the database or modifying a database and
sudden exception comes. In this situation you can use compact and repair
utility or <a href="http://www.repair-access-file.com/">access repair</a>
utility. So that you can repair your damaged database
 
That's disgusting.

Responding to Tony's very valid criticism of one company's inappropriate ad
with an equally inappropriate ad for a different company? That certainly would
not ecourage me to consider using your services, since both your ethics and
your good sense are very much called into question.

Please do NOT use these newsgroups to advertise your services.
 

Vish said:
Possible causes of database corruption is virus attack, improper shutdown,
disk failure, unexpectedly quiting the database or modifying a database and
sudden exception comes. In this situation you can use compact and repair
utility or <a href="http://www.repair-access-file.com/">access repair</a>
utility. So that you can repair your damaged database
Click to expand...

Your posting is hilarious and exceedingly foolish. You clearly did
not read my reply to your alter ago Alan.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
Back
Top