Max Sherman
max at sherman.org.uk
Wed Nov 9 02:25:30 CST 2005
EATBloatV2 is a program that I wrote (last year I think - maybe before). If you want me to email you a copy, let me know off-line. Regards Max accessd at sherman.org.uk -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: 08 November 2005 21:24 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Best way to fix database If you click the link on Bill's email it may go to this url [http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='EATBloatV2 .mdb] (square brackets used to delineate the whole url). The problem with this is that the parameter value is missing the ending single quote. Good old Outlook has trouble with urls I suppose. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, November 08, 2005 4:04 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Best way to fix database I got an error too, and the link wasn't wrapped. It got to Roger's site but the message was this: ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /Otherdownload.asp, line 32 Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos Sent: Tuesday, November 08, 2005 12:36 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Best way to fix database Hi Jim, That link worked for me OK. Did it wrap on your system due to it's length perhaps?? GK On 11/8/05, Hale, Jim <Jim.Hale at fleetpride.com> wrote: > Thanks, but the link gives an error? > Jim Hale > > -----Original Message----- > From: William Hindman [mailto:wdhindman at bellsouth.net] > Sent: Tuesday, November 08, 2005 2:28 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Best way to fix database > > > Jim > > My routine for a "flaky" mdb: > ...backup > ...save > ...compile > ...Access compact&repair > ...decompile > ...Jet Compact Utility > ...and when all else fails, rather than the normal import to a new > mdb, I try this first: > http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='EATBl > oatV2. > mdb' > ...its worked wonders for me. > > William > > ----- Original Message ----- > From: "Hale, Jim" <Jim.Hale at FleetPride.com> > To: "'Accessd (E-mail)" <accessd at databaseadvisors.com> > Sent: Tuesday, November 08, 2005 1:51 PM > Subject: [AccessD] Best way to fix database > > > > Is this the correct order of operations to fix a flaky mdb? I can't > > remember what order works best. > > > > decompile > > compile > > save > > compact and repair > > import to new container > > > > TIA > > Jim Hale > > > > ******************************************************************** > > *** > > The information transmitted is intended solely for the individual or > > entity to which it is addressed and may contain confidential and/or > > privileged material. Any review, retransmission, dissemination or > > other use of or taking action in reliance upon this information by > > persons or entities other than the intended recipient is prohibited. > > If you have received this email in error please contact the sender and > > delete the material from any computer. As a recipient of this email, > > you are responsible for screening its contents and the contents of any > > attachments for the presence of viruses. No liability is accepted for > > any damages caused by any virus transmitted by this email. > > -- > > 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 > > ********************************************************************** > * > The information transmitted is intended solely for the individual or > entity to which it is addressed and may contain confidential and/or > privileged material. Any review, retransmission, dissemination or > other use of or taking action in reliance upon this information by > persons or entities other than the intended recipient is prohibited. > If you have received this email in error please contact the sender and > delete the material from any computer. As a recipient of this email, > you are responsible for screening its contents and the contents of any > attachments for the presence of viruses. No liability is accepted for > any damages caused by any virus transmitted by this email. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.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