Uploaded October 2026 | Updated November 2026, 11 hours ago
In this Addendum, we will update the recommended SQL Server data types for Access applications, changing DateTime2 to DateTime and decimal to money for broader compatibility with VBA, ODBC, and older Access databases. I will show you how to alter existing columns, relink tables in Access, and discuss precision, compatibility, backups, and when DateTime2 or decimal may still be appropriate.
CHAPTERS:
00:00 Introduction
00:27 Updated Data Type Recommendations
02:07 DateTime2 VBA Compatibility Issue
03:48 Changing DateTime2 To DateTime
05:58 Changing Decimal To Money
06:42 Why DateTime2 And Decimal Still Have Uses
07:21 Recommended Courses
07:58 Updating The Data Type Cheat Sheet
08:45 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Addendum 1: 599cd.com/SQLSAB01L14
KEYWORDS:
Microsoft Access, SQL Server for Access Users, #msaccess, #sqlserver, SQL Server DateTime vs DateTime2, SQL Server money vs decimal, VBA DLookup type mismatch, Access SQL Server linked tables, ALTER TABLE ALTER COLUMN, SQL Server data type compatibility, Access Linked Table Manager, DateTime2 VBA compatibility, currency data types SQL Server
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this Addendum, we will update the recommended SQL Server data types for Access applications, changing DateTime2 to DateTime and decimal to money for broader compatibility with VBA, ODBC, and older Access databases. I will show you how to alter existing columns, relink tables in Access, and discuss precision, compatibility, backups, and when DateTime2 or decimal may still be appropriate.
CHAPTERS:
00:00 Introduction
00:27 Updated Data Type Recommendations
02:07 DateTime2 VBA Compatibility Issue
03:48 Changing DateTime2 To DateTime
05:58 Changing Decimal To Money
06:42 Why DateTime2 And Decimal Still Have Uses
07:21 Recommended Courses
07:58 Updating The Data Type Cheat Sheet
08:45 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Addendum 1: 599cd.com/SQLSAB01L14
KEYWORDS:
Microsoft Access, SQL Server for Access Users, #msaccess, #sqlserver, SQL Server DateTime vs DateTime2, SQL Server money vs decimal, VBA DLookup type mismatch, Access SQL Server linked tables, ALTER TABLE ALTER COLUMN, SQL Server data type compatibility, Access Linked Table Manager, DateTime2 VBA compatibility, currency data types SQL Server
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.










