Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

Database Corruption

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fred - 22 Apr 2008 23:49 GMT
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?
Chris O'C - 23 Apr 2008 00:01 GMT
Split the database and distribute a copy of the front end to each user to
save on his own hard drive.  The top reason for corruption is multiple users
sharing an unsplit database file.

Chris
Microsoft MVP

>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).  
[quoted text clipped - 9 lines]
>
>What could possibly cause the corruption?
Tony Toews [MVP] - 23 Apr 2008 00:30 GMT
>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).  

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.

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
Signature

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/

George Nicholson - 23 Apr 2008 18:20 GMT
> 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" ...
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).

Signature

HTH,
George

>I have a multi-user application that executes on a runtime on a file
>server.
[quoted text clipped - 21 lines]
>
> What could possibly cause the corruption?
Alan - 13 May 2008 15:23 GMT
On Apr 24, 1:20 am, "George Nicholson" <GeorgeNJ...@Junkmsn.com>
wrote:
> > I didn't split the database by "front-end" (forms) and "back end" (data).
>
[quoted text clipped - 40 lines]
>
> - Show quoted text -

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
Tony Toews [MVP] - 21 May 2008 05:20 GMT
>On Apr 24, 1:20 am, "George Nicholson" <GeorgeNJ...@Junkmsn.com>
>wrote:

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/

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

Tony

Signature

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/

Vish - 26 May 2008 11:56 GMT
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

> >On Apr 24, 1:20 am, "George Nicholson" <GeorgeNJ...@Junkmsn.com>
> >wrote:
[quoted text clipped - 10 lines]
>
> Tony
John W. Vinson - 26 May 2008 17:36 GMT
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.

>Possible causes of database corruption is virus attack, improper shutdown,
>disk failure, unexpectedly quiting the database or modifying a database and
[quoted text clipped - 16 lines]
>>
>> Tony
Signature


            John W. Vinson [MVP]

Tony Toews [MVP] - 26 May 2008 20:00 GMT
>> >On Apr 24, 1:20 am, "George Nicholson" <GeorgeNJ...@Junkmsn.com>
>> >wrote:
[quoted text clipped - 8 lines]
>> You also work for that company.   Posting without disclosing any
>> connection is highly unethical and sleazy.

>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

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

Tony
Signature

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 - 27 May 2008 20:51 GMT
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 - 27 May 2008 20:51 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.