Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #14447

Re: Converting 32-bit to 64-bit

Newsgroups comp.databases.ms-access
Date 2022-07-04 04:36 -0700
References <MPG.3d2a5e2c2decc0d79899fc@news.eternal-september.org>
Message-ID <ea5bbad3-e707-4ad4-b5b8-0872c693b821n@googlegroups.com> (permalink)
Subject Re: Converting 32-bit to 64-bit
From Keith Tizzard <internet.shopping@foobox.com>

Show all headers | View raw


I am not able to provide a full answer although I have progressively updated databases from early versions of Access to Office 365 over a number of years.

One feature that you should be aware of is the use of 32 bit library functions.  You will need to add the keyword 'PtrSafe'  e.g.

    Private Declare PtrSafe Function RegOpenKey Lib "advapi32" Alias "RegOpenKeyA" _
        (ByVal hKey As Long, ByVal lpValueName As String, phkResult As Long) As Long

Look at the article:

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/ptrsafe-keyword

Good luck



  


On Saturday, 2 July 2022 at 14:53:24 UTC+1, Philip Herlihy wrote:
> I figure the time is right to move to 64-bit versions of most things, including 
> my new Office 365 installation. 
> 
> I have some (crucial!) databases built years ago in Access 2013, which use 
> linked tables, so it's the "application" part I'm wary of wrecking. I can find 
> guidance on updating the VBA, but what about forms and reports? 
> 
> My database has the following References: 
> Visual Basic For Applications 
> Microsoft Access 15.0 Object Library 
> OLE Automation 
> Microsoft ActiveX Data Objects 2.1 Library 
> Microsoft DAO 3.6 Object Library 
> Microsoft Windows Common Controls 6.0 (SP6) 
> 
> Are there equivalents in 64-bit Office 365? 
> 
> 
> -- 
> 
> Phil, London

Back to comp.databases.ms-access | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Converting 32-bit to 64-bit Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2022-07-02 14:53 +0100
  Re: Converting 32-bit to 64-bit Keith Tizzard <internet.shopping@foobox.com> - 2022-07-04 04:36 -0700
    Re: Converting 32-bit to 64-bit Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2022-07-05 12:01 +0100
      Re: Converting 32-bit to 64-bit Ron Paii <ron81pai@gmail.com> - 2022-07-05 11:47 -0700
        Re: Converting 32-bit to 64-bit Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2022-07-06 11:59 +0100
          Re: Converting 32-bit to 64-bit Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2022-07-06 12:25 +0100
            Re: Converting 32-bit to 64-bit Cindy Krist <cindy@smbpartners.com> - 2022-07-06 06:20 -0700
              Re: Converting 32-bit to 64-bit Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2022-07-06 17:46 +0100

csiph-web