Changing SQL Server to DateTime & Money for Maximum Compatibility with Microsoft Access @599CD
Changing SQL Server to DateTime & Money for Maximum Compatibility with Microsoft Access  @599CD
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.
Changing SQL Server to DateTime & Money for Maximum Compatibility with Microsoft AccessProtect Your Access Code With ACCDEThe Hidden Plus Sign In Access DatasheetsBefore The Web, People Met On BBSsRegex Patterns Look Crazy Until You Learn ThisThink Microsoft Access is dead tech for 2026?Access Is The Hammer, SQL Server Is The Nail GunBefore The Internet: The Forgotten World of Bulletin Board Systems (BBSes) - Tech HistoryCustomizing the Quick Access Toolbar for a Single Database in Microsoft AccessA Dollar Sign Does Not Make It CurrencyWhy 0.1 Plus 0.2 Can Fail Equality TestsWhy Cascade Deletes Can Destroy Your Database
Computer Learning Zone |

Changing SQL Server to DateTime & Money for Maximum Compatibility with Microsoft Access

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER