Mark A Matte
markamatte at hotmail.com
Thu May 5 10:30:42 CDT 2005
Hello All, The approach I took actually worked...so I thought I'd share. A97 mdb said it needed to be repaired...after repairing it said someone else was trying to edit the same data. I could not compact or open any forms. I also could not copy, export, import, delete, or do anything to a couple of the tables. I've seen this type of corruption before and immediately went to the MEMO fields...where I found a number of corrupt records. Again I couldn't edit, delete, or do anything to these records. So...I opened a recordset with the caseID and LEN(MEMO_FIELD)...as I looped through the recordset I tested to see if LEN(MEMO_FIELD) was null or >0...if so run a query that appends just that record to my new table...when it got to a corrupt record...the LEN function caused an error...and error handling simply sent it to the next record. After, I compared case numbers from the original to the new table to display my corrupt records. Just thought I'd share...hope it helps someone. Thanks, Mark A. Matte P.S...Also, all of the objects had user security so I couldn't look at anything in design anyway, but the app would still let me open the db window...thanks to the wealth of knowledge on this list...I opened a blank db, draggedNdropped...voila...no more security. Just a reminder for those of us still using A97. Thanks Again... >From: "Mark A Matte" <markamatte at hotmail.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: accessd at databaseadvisors.com >Subject: Re: Re: [AccessD] Corrupt records >Date: Wed, 04 May 2005 21:00:05 +0000 > >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 > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com