[AccessD] Currupt records

Mark A Matte markamatte at hotmail.com
Wed May 4 15:32:08 CDT 2005


Thanks for the feedback,

I've tried repair and compact...export(bd,excel,csv),import, copy, 
dragAndDrop, delete from table, delete with query, delete field with code.

Now I'm trying to loop though each record...if its good...append to another 
table...if bad(if the code catches it) skip it...already had to tweak the 
code a few times...but I think I have it.

Anyone have any ideas in case though?

Thanks,

Mark

>From: <accma at sympatico.ca>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and 
>problemsolving	<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Currupt records
>Date: Wed, 4 May 2005 16:23:34 -0400
>
>Hi Mark,
>
>Did you try a repair and a compact?  I did get some #Error in A97 db and 
>the repair and compact always did solve it!
>
>
>
>Annie
> >
> > De: "Mark A Matte" <markamatte at hotmail.com>
> > Date: 2005/05/04 mer. PM 03:36:01 GMT-04:00
> > À: accessd at databaseadvisors.com
> > Objet: [AccessD] Currupt records
> >
> >
> > Hello All,
> >
> > I have an A97 db with some corrupt records...there are memo fields 
>reading
> > #Error...when I try to copy, delete, or edit this thing its says Jet 
>stopped
> > because me and another user are trying to change the same data at the 
>same
> > time...
> >
> > I just need to get rid of this record.
> >
> > Any Suggestions?
> >
> > Thanks,
> >
> > Mark A. Matte
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list