[thelist] Problems with deleted records in Access

S Finley fins5901 at hal.humberc.on.ca
Tue Nov 7 09:09:59 CST 2000


Not sure if this will help - but I've used Access extensivly - depending
on what your doing and the order of operations you might have to 'commit'
your sql transaction before performing another - also flushing the cache
may help.


On Wed, 8 Nov 2000, Oliver Lineham wrote:

> 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 !
>





More information about the thelist mailing list