[AccessD] 32->64 bit conversion

[John Colby]

>From what I know, runtime mode simply uses various database properties to
lock down the database.  It does not perform a compile and create an
ACCDE.

Some may remember that I created a C2DbProperties db which I use to set and
reset those properties.  This allows me to lock a database and unlock it
later.  In the absence of a tool such as mine, it is difficult for an
average user to "break in" to a locked down database.  With said tool it is
trivial.

In the company I have been discussing, I created an administrative db
starting from my C2DbProperties.  This is the db which I use to open
Outlook and sink mail events, processing said events to send out product to
buyers.  With this property stuff built in from the start, it allows me to
do all that manipulation in situ.  BTW I do compile the tartge db to an
ACCDE which removes the English VBA.  Just in case!

On Mon, Nov 1, 2021 at 4:18 AM Bill Benson <bensonforums at gmail.com> wrote:

> oh duh ... right! Sorry.
>
> On Mon, Nov 1, 2021 at 4:16 AM Jim Dettman via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > Bill,
> >
> > << By that all I know is that we take the ACCDB and swap the last letter
> of
> > the extension. >>
> >
> >    You may be thinking instead of replacing the .accdb with .accdr, which
> > forces runtime mode.
> >
> > Jim.
> >
> > -----Original Message-----
> > From: AccessD On Behalf Of Bill Benson
> > Sent: Monday, November 1, 2021 3:49 AM
> > To: Access Developers discussion and problem solving
> > <accessd at databaseadvisors.com>
> > Subject: Re: [AccessD] 32->64 bit conversion
> >
> > Well, you could be right in your disbelief, maybe I am overstating the
> > effect of "distributing as ACCDE". By that all I know is that we take the
> > ACCDB and swap the last letter of the extension. Access treats the file
> as
> > an ACCDE and will not let the users near the code. We do not do anything
> in
> > particular to compile (and I wouldn't know how to uncompile) the tool
> > beyond what Debug | Compile does in the VBA IDE..
> >
> > On Mon, Nov 1, 2021 at 2:34 AM Stuart McLachlan <stuart at lexacorp.com.pg>
> > wrote:
> >
> > > I find that very hard to believe.
> > >
> > > There are no "conditional compilation constants" in an ACCDE file.  It
> > > only contains the cP
> > > code compiled from the text source code which is not present in an
> accde
> > >
> > >
> > >
> >
> >
> https://support.microsoft.com/en-us/office/hide-vba-code-from-users-ce6ab610
> > -af07-4008-9
> > <
> https://support.microsoft.com/en-us/office/hide-vba-code-from-users-ce6ab610-af07-4008-9
> >
> > > 1e0-1ef1b796ff18
> > >
> > <
> >
> https://support.microsoft.com/en-us/office/hide-vba-code-from-users-ce6ab61
> > 0-af07-4008-91e0-1ef1b796ff18
> > <
> https://support.microsoft.com/en-us/office/hide-vba-code-from-users-ce6ab610-af07-4008-91e0-1ef1b796ff18
> >
> > >
> > > "Saving a database as an .accde file compiles all VBA code modules,
> > > removes all
> > > editable source code, and compacts the destination database."
> > >
> > >
> > >
> > > On 31 Oct 2021 at 23:22, Bill Benson wrote:
> > >
> > > > I am going to have to check that out because we distributed accde
> > > > versions to bank clients running both 2013 32 bit and 365 64 bit with
> > > > conditional compilation constants amidst api calls and have not had a
> > > > single customer service complaint in over a year.
> > > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting