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
5 Comments. Leave new
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. 🙁