[AccessD] Missing records

We had something similar happen here a while back. I was able to
import the missing records from a backup into the compacted and
repaired current copy - the first thing I did when they said things
were not working right was compact and repair - so that they didn't
lose other updates and adds since the backup had been done two nights
before. I created a third database and linked the main transaction
tables from both versions and did an outer join to see what was in the
old that was not in the new and then created a temporary table of
those missing records which I then reviewed to be sure they should be
readded and then finally did an append to put them into the current
table. Fortunately this database is pretty much denormalized so most
everything is in a single table and only that table was missing
anything. We blamed network issues but really didn't have a "for sure
that is what happened" explanation. It hadn't happened before or
since.

GK

On 2/3/06, John Clark <John.Clark at niagaracounty.com> wrote:
> We got a call from a department that has a small Access 2K db.
> "Something" has happened, and they are missing about a quarter of their
> records. This was being investigated by a technician and I was just
> asked the following question:
>
> If a PC is "hard-booted" can an Access DB lose records w/out showing
> signs of corruption (i.e. the db still runs)?"
>
> I really don't know the answer to this question. I have had nearly no
> experience w/db corruption, since starting with Access 5 years ago. I
> used to use FoxPro...there are still some old FoxPro 2.6 (DOS) dbs
> hanging around actually...and corruption was a huge problem w/them.
>
> Anyone got any tips on this?
>
> Thanks!
>
> John W Clark
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com