Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Fri Feb 12 14:18:22 CST 2010
<<< The rebuild was an extreme solution for an extreme problem, but it worked. >>> Hi Ken -- Was that work code by code or manually? Thank you. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert Sent: Friday, February 12, 2010 10:54 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Add-In Express 2009 for Office and .NET > > Stuart McLachlan: > AFAIK, that will create a new form with the counter initialised. > That's one of the things that EATBloat does do for you. > > >Rocky Smolin: > > If you hit the limit can you export the form to a text file and then > > reimport it to reset the object counter? > > > Doing an export/import using SaveAsText/LoadFromText does NOT reset the counter. This is certainly true in A2K -- I tested that with very large forms, and verified it. Also, this type of restore does not fix certain kinds of bloat-causing corruption. I verified that too, again in A2K. It also turns out that manually editing the "ItemSuffix" attribute in the form text file isn't reliable. See my earlier response to Max. Also, Access got grumpy on certain of our problem forms when this trick was tried. This was one of the motivations for doing the much more involved rebuild from scratch, control-by-control, property-by-property. Development was grinding to a halt, and none of the standard measures fixed the problem. The rebuild was an extreme solution for an extreme problem, but it worked. I would be very interested to see testing done in versions of Access later than 2000, to see if this behavior still exists. -Ken -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4861 (20100212) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru __________ Information from ESET NOD32 Antivirus, version of virus signature database 4861 (20100212) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru