[AccessD] Export/Import all Objects

[Dan Waters]

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