[thelist] Problems with deleted records in Access

[Chris Hayes]

Just a point.. you have compacted and repaired the DB?

Sorry if this was mentioned already but I haven't the time this morning to
go through the lot.

Regards


"Oliver Lineham" <oliver at lineham.co.nz> wrote in message
news:4.2.0.58.20001108022339.017c4ce8 at mail.paradise.net.nz...
> Hi all,
>
> I'm using an Access database for a site (with CF, not that it matters),
and
> noticed something funny happen when I deleted some records in a table.
>
> Deleting the records was fine, but when a new record was added later one
or
> two of the deleted records reappeared.  I deleted them again, but the
> reappeared again when more records were added.
>
> This freaked me out - if it happens when the site is "live" it could be a
> real disaster.
>
> Is this a known problem with Access?  Obviously it is a problem with the
> table index getting corrupt, but does anyone know what might have caused
> that to happen?
>
> One solution I might use is to never delete records, and just use a
> "deleted" boolean field - but this is a pain, complicates every query on
> the site, and would waste space.  Perhaps a "deleted" field is a good way
> to design databases regardless - i'm not sure.
>
> Any insight at all appreciated.
>
> </ol>
>
> ____________________________________________________
>      v i b e   m e d i a    http://www.vibe.co.nz/
>   po box 10-492              wellington, new zealand
>   phone +64 21 210-7845         oliver at lineham.co.nz
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !