In this episode, I'm taking you on a journey to explore my first deployment of SQL Server as a backend, using just the database engine which was called MSDE (in the old days). This engine was packaged with MS Access, and then later became what you all know as SQL Server Express. It took just one deployment of a MSDE/SQL Server backend to show me the tight integration work that was done to make MS Access integrate seamlessly with SQL Server for companies that were scaling past the JET/ACE environment. I was really impressed when I saw that my client's app, with almost no changes to the front end, would work just as it had before, but faster and with more stability. After converting their data and connecting with ODBC linked tables, I couldn't believe how good it was!
Related Videos:
How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend
You are watching this video now!
How to Install and Use SQL Express
[ Ссылка ]
How to Design Tables in SQL Express for Use with MS Access
[ Ссылка ]
For developers looking for a new role, check out and sign up:
[ Ссылка ]
Needing to hire technical resources for your project? Get the best:
[ Ссылка ]
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
[ Ссылка ]
Demo of my BZ RDP Cloaker:
[ Ссылка ]
Contact form you can find at [ Ссылка ]
Follow me on social media:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Get Microsoft Office including Access:
[ Ссылка ]
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
[ Ссылка ]
#msaccess #dataengineering #azuresql
