Make Your Microsoft Access Databases Safe with 32-Bit and 64-Bit Versions of Office, PtrSafe
23.6 هزار بار بازدید -
3 سال پیش
-
In this video, I will
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 statemsnts and then mark them with the PtrSafe attribute." What do I do?
Silver Members and up get access to an Extended Cut of this video. 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.
MEMBERS VIDEO:
32-Bit to 64-Bit Microsoft Access - M...
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/64bit
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
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
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 statemsnts and then mark them with the PtrSafe attribute." What do I do?
Silver Members and up get access to an Extended Cut of this video. 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.
MEMBERS VIDEO:
32-Bit to 64-Bit Microsoft Access - M...
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/64bit
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
COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
3 سال پیش
در تاریخ 1400/04/30 منتشر شده
است.
23,665
بـار بازدید شده