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 Design Tables in SQL Express for Use with MS Access

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

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:

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

[interestingamerican]

This real world scenario really helps me visualize where I am at and where I want to go. This is mentorship in story telling.

[musisir]

I like the calmness and the content ofcourse.

[Vije]

Very informative. I was looking for this answer since from 2014, when I started using MS ACCESS for our projects only by using LAN connection. Now I will try to upsize to SQL Server, to get more speed.

[jamesmartinez]

Excelente Señor Sean, muchas gracias por compartir su experiencia y conocimiento.

[abderazzaq.es-seddyqy]

First of all, thank you for this excellent information. I have an Access database and I would like to convert it to work with SQL Server. However, I am confused between using linked tables or using DAO. Based on your experience, which is better? Thank you.

[dataArtists]

Another great video! Can use SSMA to move from Access to Azure DB for back end. Perhaps have local SQL Server backend for speed (OLTP) and use Transactional Replication to an Azure SQL DB for just a "Reporting Database" (OLAP) as well as offsite backup.

[YvesAustin]

Thank you for another great instructional video. Are there any limitations as to how the BE of the Access DB is built that may create issues when upsizing to SQL Azure? What about tables containing lookup fields? These are easy to create in Access! Any other watch-outs to consider? I am an Access enthusiast although still a newbie! (you may already have a video related to this topic - thank you again Sean).

[hasanmougharbel]

Glad to meet again..
As a new sql learner i hold a simple enquiry.
SQL Server 10.50.4000
How these numbers (10.50.4000) reveal anything about the version of sql server?
Thanks a lot

[erik-janvriens]

Interesting video! Do you have an instructional video to move ms-access data to SQL Server or Express and connect to it with ms-access?

[digitalmasters]

Respected Sir, Please make a video that how to deal on Multiple Checkbox field for frontend of MS access and Backend SQL Database. Thanking you anticipation

[hayaizrinontheway]

Hi....How to connect to SQL server from different netwofk

[shailendrasoliya]

Sir i have student database system in ms access how to connect student photos field with sql server please make a video on it

[gerfer]

Don’t this require high end of sql knowledge and admin rights?
SharePoint?

[donharrold]

Why not just deploy SQL Express and ditch Access?

[triyankaery]

I Sean,

I always find your videos very informative and would like to thank you for this.

I am pretty new to MS Access and have a question regarding one of the issues I'm facing. I would like to request your assistance and would appreciate it if you can share your thoughts.

Kindly share your email address or your inbox link where I can share the details with you.

Looking forward to hearing from you.

Thank you!