How to connect to Microsoft SQL Server in Microsoft Access

Microsoft Access is my number one to-go choice when I need to build an database application fast, especially when the platform offers reporting, query, and form development functions, and its ability to connect to 3rd-party database systems.

In this video, I am going to demonstrate the steps how to connect to a Microsoft SQL Server in Access.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#MSAccess #Access #MicrosoftAccess #SQLServer

[ricksegalCanada]

This super helpful and a solid 6 minutes of value. Thanks for doing this.

[bwong]

Great video! Very clear and I was able to get everything I needed connect. Thank you!

[MrLuiz]

Really helpful, thanks for sharing :)

[mgcezz]

This is so helpful to me thank you so much

[carlostdcjr]

Thanks my man! It saved a lot of time. I've been searching for a simple front-end to my sql database and Access still is the best option and coding free. Regards!

[akshaygatkal]

i was laughing out loud when you say Ass's. Me and my collogue are watching your video. Your video is too helpful for me. Thanks for the video.

[kevinmcloughlin]

Hi @JieJenn- After follow your steps by linking a table, I have created more tables in MS SQL Server but MS Access aren't updated with the new tables in MS SQL Server. How do I update it?

[danki]

Hi. I am having trouble editing a table in Access. Can you please tell me how to solve this problem.

[mgcezz]

How do I then connect from Ms Access to Sql in another computer

[Mohamed.GadAllah]

Does using this method will help to bypass and avoid the 2 GB database size limit?

[AABradyKK]

Why use SQL native 11.0 instead of ODBC Driver 17 for SQL Server?