Access Europe – Peter Cole (32 to 64-bit Conversion)

Session Outline

With the default installation for Microsoft Office now being 64-bit, it has become even more important that Access databases should be able to run on both 32 and 64-bit.

The main consideration is normally the need to convert API declarations for use in 64-bit Access.

Although Microsoft do provide a text file with documentation to assist with the conversions, they do not supply a tool for making the changes needed and the conversion process can be both tedious and time consuming

Peter will demonstrate his free scanner that shows the number of declare statements in a database providing an idea of the size of the updating task. He will demonstrate the free API Viewer that provides the declarations for 64-bit.

He will then demonstrate his 32 to 64-bit updater showing some sample updates.

Here are some of the topics we’ll cover:

  • What needs to be updated
  • Showing the size of the problem with the API scanner
  • The “Unknown” calls. (Declarations that are not in the Microsoft text file)
  • Creating update for unknowns from the scanner output
  • The API Viewer and manual updates
  • How the scanner works – the module object
  • The auto updater
  • Scope is important
  • Why not to use #IF VBA7
  • Where you actually need #If Win64 (much less than you think!)

Bio

Peter is the owner of ThemeMyDatabase where he developed an add-in for adding a new look to a database using themes. Having updated several databases to run on 32 and 64 he concluded that the very tedious process could be automated. Updating the declarations was relatively straight forward, However, auto updating the calling code is very convoluted!

Peter’s website is https://thememydatabase.co.uk

 

Do join us

======================================================================

IMPORTANT NOTE

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTubeAccessUserGroups.org – YouTube.

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off.

======================================================================

We are planning to try out Zoom as our meeting application.

Please click the link below to download Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link or phone number

Join Zoom Meeting

If you are asked:

Meeting ID: 924 3129 5683
Passcode: 661210

Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands

+48 22 307 3488 Poland
+351 308 810 988 Portugal
+40 31 630 1088 Romania
+421 233 418 515 Slovakia
+386 1600 3102 Slovenia
+34 917 873 431 Spain
+41 43 210 71 08 Switzerland
+46 850 539 728 Sweden
+44 203 481 5240 United Kingdom
+44 208 080 6591 United Kingdom

Meeting ID: 924 3129 5683
Passcode: 661210
Find your local number: https://zoom.us/u/a4d0JdR88