Dan Waters
df.waters at comcast.net
Sat Dec 24 11:58:38 CST 2011
Hi William, I have a version of this that I made for myself. It works on all objects except tables. I can email a copy to you offline if you'd like. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson Sent: Saturday, December 24, 2011 11:44 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] EatBloat latest version?? availability --- EIasT - further review I am missing the original message where this EIasT.mdb was described / offered. Reading this message leaves me curious. May I ask someone to send me this link offlist? On Nov 19, 2011 9:13 AM, "Jack and Pat" <drawbridgej at sympatico.ca> wrote: > Dan, > > > > Further to my (off list) note from late last night, I did a little > more review. I opened the EIasT.mdb with a breakpoint to allow > stepping thru the code. In the problem data base, the queries and > forms - up to the problem form - are all exported as text as expected. > After the error, the code stops on a STOP statement, as it should. If > I step through, it continues with the next procedure in code and does > Import the text that was previously exported. > > > > It seems I have a corrupted Form and that its source can not be retrieved. > I > did not find any resolution to the "there isn't enough memory to > perform this operation. Close unneeded programs and try the operation > again". Seems the consensus is to rebuild the form involved. > > > > So from an EIasT view, I did use the utility against another database > and all was well. It did build a directory and saved all queries, > forms, reports and nodules (I don't have any macros), It did import > all the text. It does Compact and Repair. And the database , original > and rebuilt are available. > Good stuuf. > > > > I'm impressed with your code. No wasted code; very concise. I > especially like the line numbers in the vba. I take it that is based > on your use of FMC utilities. The progress bars are a nice feature - > seems there are lots of people trying to build these based on forums > I've seen. > > > > Again, thanks for responding quickly, and thanks for the EIasT code. > Perhaps it should be made available at databaseadvisors as a utility. > > > > Jack > > -- > 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