Doug Broke It: Microsoft Access Data Types [Video]
In this video, Doug talks about how changing a column’s data type in SQL Server can be dangerous when there are Access clients using it, and a reference table to help avoid type mismatches when planning data type changes.
Click here to see the list of SQL Server data types according to Access.
https://youtu.be/vSBnnpcxvjc
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
The link above gives a 404 Error — Page Not Found
Thanks, Eric. We’ve fixed the link and sent it a sternly-worded letter telling it to never 404 again.
FYI, your link for the data types is a 404.
Thanks, Bruce. Should be working now.
Here 2020, and I have to port Access applications to SQL Server 2019.
Thank you for your solidarity in advance. 🙁