How to connect to Microsoft SQL Server in Microsoft Access

Подписаться 64 тыс.

Просмотров 87 тыс.

50% 1

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.
📺 How To Build A MS SQL Server SQL Query Tool Using Excel: • Building A MS SQL Serv...
► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood...
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: / jiejenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → / madeinpython
📘 More tutorial videos on my website → LearnDataAnaly...
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: RU-vid@LearnDataAnalysis.org
#MSAccess #Access #MicrosoftAccess #SQLServer

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@ricksegalCanada 3 года назад

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

@carlostdcjr 3 года назад

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 3 года назад

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.

@rowanmcglasson688 Год назад

This video was helpful, thank you! 🙂

@b33wong87 3 года назад

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

@akshaygatkal4588 2 года назад

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.

@mgcezz2154 Год назад

This is so helpful to me thank you so much

@MrLuiz110 3 года назад

Really helpful, thanks for sharing :)

@seanmccarthy8734 3 года назад

Great video, thanks so much.

@Saimaddipoti 2 года назад

Thank you man.

@himanshuaswal5286 2 года назад

Thank you for doing this:)

@456iner 2 года назад

Thank you

@rusbelhernandez4834 3 года назад

Great video! congrats!

@alosh3260 Год назад

You help me think you

@AyrForce 2 года назад

thanks mate really usefull

@danki236 10 месяцев назад

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

@catalinaorrego590 2 года назад

Excellent!! Thanks

@jiejenn 2 года назад

Glad the video helped.

@afzaalawan 3 года назад

very good

@mgcezz2154 Год назад

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

@kevinmcloughlin5988 3 года назад

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 3 года назад

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

@kevinmcloughlin5988 3 года назад

@@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 3 года назад

Does the question make sense?

@Mohamed.GadAllah 3 года назад

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

@jiejenn 3 года назад

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

@Mohamed.GadAllah 3 года назад

@@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 :)