How to connect to Microsoft SQL Server in Microsoft Access

[@ricksegalCanada]

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

[@rowanmcglasson688]

This video was helpful, thank you! 🙂

[@akshaygatkal4588]

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.

[@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!

[@jiejenn]

Glad my video helped.

[@Igor-oc4om]

I have been using the MS Access database for a long time, and now I would like the data to be saved in the sql server on my qnap device locally. What is the cost of SQL Server if I use it locally and would that be a good solution?

[@carlostdcjr]

@@Igor-oc4om I use the Express Edition, for my need it fit perfectly. In the official page you can find the limitations and requirements.

[@b33wong87]

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

[@mgcezz2154]

This is so helpful to me thank you so much

[@MrLuiz110]

Really helpful, thanks for sharing :)

[@rusbelhernandez4834]

Great video! congrats!

[@seanmccarthy8734]

Great video, thanks so much.

[@himanshuaswal5286]

Thank you for doing this:)

[@Saimaddipoti]

Thank you man.

[@danki236]

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

[@AyrForce]

thanks mate really usefull

[@catalinaorrego590]

Excellent!! Thanks

[@jiejenn]

Glad the video helped.

[@RussianAdmin-p1i]

hi. getting error 7748. any idea? appreciate.

[@mgcezz2154]

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?

[@jiejenn]

Yup, it will since your actual data is stored in a different place.

[@Mohamed.GadAllah]

@@jiejenn You mean if I did that with all tables in the database I will be safe? What other issues would you recommend me to do and learn to avoid technical problems later on? I hope that I can do connect all Access form to Microsoft SQL server and use Access as a front end and MS SQL Server as a back end. Liked & Subscribed :)

[@kevinmcloughlin5988]

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?

[@jiejenn]

Not sure if I understand your question. Have you refresh the connection to update the table list?

[@kevinmcloughlin5988]

@@jiejenn so When I was doing your steps…I linked only one table…and ms access was updated with that table. And then I added a few more tables in ms SQL server DB but MS access is still showing only one table (the linked table)….how do I refresh the connection? Thanks

[@kevinmcloughlin5988]

Does the question make sense?

[@456iner]

Thank you

[@alosh3260]

You help me think you

[@AABradyKK]

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

[@jiejenn]

ODVC Driver is preferred if your application is gonna be on different OS systems. SQL native is Windows preferred and I'm on Windows.

[@afzaalawan]

very good

[@surajsurvase1126]

ok