Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corruption in Data (2000 SR2)

    Hi

    Following on in the same vane as the post on corrupt forms. I have been thinking recently about corrupt data.

    We are thinking about supplying (free so minimal support is wanted) to some of our 'clients' / 'colleauges' a small Access database that will allow them to import text files, add some data then export complete dataset to a text file etc...

    These people that we will be supplying with the databases are 'novice' users. This is no problem from an application point of view, all the forms are / will be nice and friendly.

    When distributing it, I intend to go to each site and install the databases for them ... splitting the data from the front ends. The front ends will be .mde and the back ends will be Acc 2000 mdbs.

    My questions, is in everyones experience, what is the best way to deal with corrupt data in the mdb file and reparing the database, given that we don't want to have to support them too much?

    I am thinking something along the lines of performing a 'compact/repair' on the data mdb file each time the front-end database is closed? Or something similar.

    Any other ideas, or what you think of the above Idea?

    Cheers

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Corruption in Data (2000 SR2)

    Since you're using Access 2000, you can set the backend up to automatically compact on close. If the database is not going to be really large, this is the simplest way to handle it. I've been working with Access since version 1.0 and can't remember every encountering data corruption that wasn't associated with memo fields. As a result, I avoid memo fields.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corruption in Data (2000 SR2)

    As an aside, at work we have an Acc 2000 database without any memo fields and it needs repairing on a regular basis (about monthly).

    I suspect this high rate of failure is due to
    (i) 3 data entry operators entering into database
    (ii) resonably large database

    The option to automatically compact on close is a good one - hadn't even thought of this...isn't it funny how sometimes the obivous answers are the ones that you miss <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Thanks heaps Charlotte this should deal to the potential problem.

    J

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •