William Benson
vbacreations at gmail.com
Sat Dec 24 12:01:18 CST 2011
For sure! THANKS IN ADVANCE. On Dec 24, 2011 1:00 PM, "Dan Waters" <df.waters at comcast.net> wrote: > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >