[AccessD] Export/Import all Objects

Fred Hooper fahooper at gmail.com
Thu Jul 27 15:23:17 CDT 2017


Hi Dan,

I'll see what I can do about rewriting it for 2002 -- that's what I deserve
for staying in the dark ages.

I think the file was open; it created two other access files. Tomorrow I'll
look at it more carefully. I'll keep notes that might help someone else
with other Access versions.

Best,
Fred

On Thu, Jul 27, 2017 at 3:55 PM Dan Waters <df.waters at outlook.com> wrote:

> Hi Fred,
>
> I make this in Access 2010 so it probably does not work in Access 2002.
> I've had people use this in Access 2010 and up, but not previous version.
>
> Perhaps you could rewrite it or make a workaround for Access 2002?  I
> don't have a copy anymore.
>
> Dan
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Fred Hooper
> Sent: July 27, 2017 14:35
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Export/Import all Objects
>
> Is it intended to work on 2002? I'm running into errors in code related to
> the version number.
>
> Specifically,
>
>   * tblAccessOptions includes headings for Version10 (2002) and
>     Version11 (2003). The Switch function in TransferOptions Line 3 is
>     only populated for 12, 14 & 15 -- so it fails.
>   * tblAccessProperties has headings for Access11, Access12, Access14 &
>     Access15, but 14 is all true and the others are all false. The code
>     in TransferProperties Line 6 requires the appropriate AccessNN be
>     True -- and only Access14 has any True values.
>
> The combination of these makes me think that this copy will only work for
> Access14.
>
> Best,
> Fred
> > Dan Waters <mailto:df.waters at outlook.com> Thursday, July 27, 2017 3:02
> > PM Hi Rocky,
> >
> > Looks like you can download it from http://www.camcopng.com/decorrupter.
> >
> > Enjoy!
> > Dan
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Rocky Smolin
> > Sent: July 27, 2017 12:32
> > To: 'Access Developers discussion and problem solving'
> > Subject: Re: [AccessD] Export/Import all Objects
> >
> > Woo-hoo! Thank you. Please send to rocky.smolin at bchacc.com.
> >
> > Best,
> >
> > R
> >
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Dan Waters
> > Sent: Thursday, July 27, 2017 9:34 AM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Export/Import all Objects
> >
> > I do and it's now called the DeCorrupter! But someone put a copy on
> > their website to make it easily available for downloading and I don't
> > remember who that was.
> >
> > If anyone would like a copy let me know and I'll send it off-line.
> >
> > Dan
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of jack drawbridge
> > Sent: July 27, 2017 10:06
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Export/Import all Objects
> >
> > Rocky,
> >
> > I'm not positive, but , as I recall, Dan Waters had a routine
> > (originally called EatBloat or similar) that would do a save as text
> > of all objects and had option to do a Load From text. I repeat I'm not
> > positive.
> >
> > Good luck.
> >
> > On Thu, Jul 27, 2017 at 10:21 AM, Rocky Smolin
> > <rockysmolin at bchacc.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
> >
>
> --
> 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
>


More information about the AccessD mailing list