Make Databases Safe for 32-Bit and 64-Bit Office

In this video, I will show you how to take your existing 32-bit Access databases and upgrade their VBA code to run under 64-bit Office using the PtrSafe attribute.

Ethan from Hastings, England (a Platinum Member) asks: I just upgraded from 32-bit to 64-bit Office, and my Access database which I have been using for years is now telling me "the code in this project must be updated for use in 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute." What do I do?

Members

Members will learn a few more things about migrating from 32-bit to 64-bit including the new VBA7 compiler pre-directive for maintaining multiple versions of your database. We'll also talk about the new data types like LongLong and LongPtr, and when you would need to use them, and we'll discuss issues that come up with maintaining multiple versions of your database for 32-bit and 64-bit users, with possible different versions of Access, and with ACCDE files.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Intro to VBA: https://599cd.com/IntroVBA
• Microsoft 64 Bit Article: https://tinyurl.com/yznvn5r3
• Excellent Page by Philipp Stiefel: https://tinyurl.com/yzb3kxrj
• My 32-bit vs. 64-bit Page: https://599cd.com/32v64bit
• Mike Wolfe: 32-bit vs. 64-bit Access in 2023
• New: Another great Mike Wolfe article: 32-bit vs. 64-bit VBA: Deep Dive

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, microsoft office, 32-bit, 32 bit, 64-bit, 64-bit, declare, ptrsafe, longlong, longptr, Win64, VBA7, sleep function, kernel32