[AccessD] Export/Import all Objects

[Fred Hooper]

Hi Dan,

I've gotten it to work (mostly, details below) on the 2002 project that 
I've taken over from someone who wrote it as their first big project 15 
years ago. To do so I made the following changes (documented in the 
Other Access Versions module that I added):

  * Edited the Switch function in TransferOptions, line 3 to include the
    2002 and 2003 versions (a/k/a 10 & 11). As the appropriate columns
    in tblAccessOptions were already populated I didn't think I needed
    to do more.
  * Wrote and ran code (it's in the new module for use with other Access
    versions) to test the values already in tblAccessProperties, I added
    the Access10 field that I needed to hold the results.
      o These were all True (as for A14) except AllowByPassKey,
        AllowBreakIntoCode & AppIcon -- all of which my project uses. I
        left them False as the project sets them automatically -- as I
        expect all do that use the first two and the need for the third
        will be obvious.
      o I expect that Access 11 (2003) would work the same way, but I
        haven't made any changes in the table for that version. As I
        haven't extensively used anything more modern I don't know about
        later versions.
  * I had one form and three reports that wouldn't export to text. As
    these are rarely used in the project, I added code to DeCorrupter to
    save their names in a new table, tblExportFailures (and manually
    imported them into the DeCorrupted version). All code related to
    these changes currently runs only on my PC (If
    Environ("computername") = "PUGET-88049"), as this change may not be
    desirable to others. If someone *does* want this code to run, they
    could search/replace their computer name.

I haven't completed testing of the DeCorrupted copy of the project, but 
compile found four places where changes were needed that were obscured 
by (presumed) corruption in the source copy; I looked closely in the 
source but couldn't find any reason that it should have compiled.

I'm happy to email it to anyone who would like a copy of the changed 
program.

Best,
Fred
> Dan Waters <mailto:df.waters at outlook.com>
> Thursday, July 27, 2017 3:54 PM
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com