Re: Database Corruption

Fred <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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
--
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/
.

Relevant Pages

  • Re: FE/BE question
    ... be using the exact same forms and reports and not creating their own, ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: My 2007 is very slow, please help
    ... The below mentioned Auto FE Updater will help with some of your pain. ... I specifically created the Auto FE Updater utility so that I could ... Access Performance FAQ page at ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: My 2007 is very slow, please help
    ... My FEs are not MDEs, ... The below mentioned Auto FE Updater will help with some of your pain. ... I specifically created the Auto FE Updater utility so that I could ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Local Copy: Will It Solve Read Only Problem?
    ... on each local machine, however, no one explains how to do ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Citrix occasionally corrupting row of data.
    ... You can view the actual screen shot here ... ... When the database was closed, ... This comes in quite useful in tracking corruptions. ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)