How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend

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 Install and Use SQL Express  
How to Design Tables in SQL Express for Use with MS Access
   • How to Design Tables in SQL Express f...  

Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#msaccess #dataengineering #azuresql