William Hindman
wdhindman at dejpolsystems.com
Thu Feb 18 13:47:21 CST 2010
Dan ...that was the most frustrating part ...no feedback ...just an eternal hourglass until I killed it ...there was an error msg on the first go round but I didn't log it ...couldn't create object iirc. William -------------------------------------------------- From: "Dan Waters" <dwaters at usinternet.com> Sent: Thursday, February 18, 2010 2:26 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers > Thanks William, > > No error messages? > > I am going to add in a DoEvents between each objects export and import. > > Other than that I can't say what was not working. It's worked for me many > times. > > Thanks! > Dan > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Thursday, February 18, 2010 1:17 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers > > Dan > > I've spent the past three hours with a vanilla A2k3 mdb, decompiled and > compacted, trying to get your version to run. > > I printed out and followed your instructions and notes to the letter. > > First run was very slow but finally exported as csv ok ...failed to import > anything into new mdb. > > Compacted and ran again. Takes forever. Killed the process, rebooted, > deleted the form, decompiled and compacted. > > Imported, compacted, decompiled, compacted. > > Tried again ...this time I let it cook for 40 minutes before killing it > ...it was half way through the queries ...this is a 15mb mdb. > > I'm going to give Max's new version a spin. Let me know if you do any > updates. > > William > > > > -------------------------------------------------- > From: "Dan Waters" <dwaters at usinternet.com> > Sent: Wednesday, February 17, 2010 12:43 PM > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Subject: [AccessD] New Export As Text (EAT) Form - Need Beta Testers > >> Good Morning! >> >> I've mentioned a few times that I was working on upgrading Max's EATBloat >> form (having started last year!). >> >> This is a significant change: >> >> There are 2 listboxes to quickly manage the objects to be exported. >> >> The objects are all exported to the same export folder, which is date >> and >> time stamped. The text files have prefix names to correspond with which >> type of object it is so you can quickly select what you want to import. >> >> You can quickly include or exclude linked tables. >> >> I have only used this in Access 2003. >> >> I have not tried to use this yet with any database other than the >> Current >> Database. >> >> >> To get a copy: >> http://www.promationsystems.com/databaseadvisors.htm >> >> Download the EAT.pdf file, and then change the extension to .mdb. Then >> place the single form, frmEAT, into your database. >> >> Please review the pages titled About, Steps, and Notes. >> >> >> If you have some ideas or find some problems please respond using my >> email >> address at dwaters at usinternet.com. >> >> >> Thanks! >> Dan >> >> >> >> >> -- >> 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 >