Mark A Matte
markamatte at hotmail.com
Wed May 4 16:00:05 CDT 2005
Annie, This db has been removed from the network and resides on my local machine. Just a note I did NOT build this one...when they first showed it to me...I warned that it was poorly written and this would eventually happen. I'm kinda the UN-official last resort to get back into it. I think my looping strategy might work...but I keep running into walls after about 20k records...I'll share the end results if anyone's interested in the results. 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: Re: [AccessD] Currupt records >Date: Wed, 4 May 2005 16:47:51 -0400 > >Mark, > >Have you tried to add your record to another table using a query? Also, is >your data on a server or shared computer? You might want to try to closed >up all computer and restart only the one with the data and then try again a >repair and compact. I've found that with A97, closing every computer can >solve a few problems. > >Annie > > > > > De: "Mark A Matte" <markamatte at hotmail.com> > > Date: 2005/05/04 mer. PM 04:32:08 GMT-04:00 > > À: accessd at databaseadvisors.com > > Objet: Re: [AccessD] Currupt records > > > > 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 > > > > > > -- > > 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