[AccessD] 32->64 bit conversion

[Bill Benson]

I think VBA7 is VBA 7 regardless whether Access or Excel etc.

API calls are agnostic which program is calling them from my experience.

Only time I have had issues is when there are references to other Office
programs, whatever you added a reference for, a different version of Access
won’t make any effort to find other programs, only the main Office and
Access refs get auto-updated.

I know I upgraded a few Access VBA projects to 64 bit from 32 bit and there
was no difference in how I did it than Excel, and it worked fine on Office
2013 32 bit and Office 365 64 bit so long as I used the #If VBA7 and/or #IF
Win64.

On Thu, Oct 28, 2021 at 4:59 PM Paul Wolstenholme <
Paul.W at industrialcontrol.co.nz> wrote:

> I have wondered about how conditional compilation works with Access.
> I understand Access likes to pre-compile its source and save it in the
> database file (the front end in a FE-BE system).
> The database file can be distributed and even shared in a multi-user
> environment.
> So perhaps the computer that was used for compilation is not necessarily
> the computer that executes the compiled code.
> If the source is written for conditional compilation (conditional according
> to how Access was installed on the computer) how does Access know when
> recompilation is required?
>
> One could avoid the issue by always decompiling the Access database before
> another computer uses it and never sharing an Access database except as a
> back end.
> But Access wasn't designed with that limitation.
>
> Should conditional compilation only be used in Access with some prescribed
> caveats?
>
> Paul Wolstenholme
>
>
>
> > On Thu, Oct 28, 2021 at 11:59 AM Bill Benson <bensonforums at gmail.com>
> > wrote:
> > ...
> > > When I was on a massive upscaling project, one with a lot of 32 bit API
> > > functions pre-existing in the code, I would put wrappers around that
> luke
> > >
> > > #If VBA7 Then
> > >      The declarations that are 64 bit
> > >       Office Compatible
> > > #Else
> > >       The declarations that were 32 bit
> > >       Office Compatible
> > > #End If
> > >
> > >
> > > Sometimes in addition or in substitution one would have also
> > >
> > > #If WIN64 Then…
> > >
> > > Etc.
> > >
> > > That is what conditional compilation is. Unfortunately this was only
> > > sometimes all my code required. Often I had to change how many of the
> > > variables in the rest of my code were declared as well. It is a long
> > > learning curve (or was for me) and took a long time to properly upgrade
> > > large apps to work in both environments. I think reading some of the
> > links
> > > others provided may be worth your time.
> > >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>