How to Use Streamlit with Microsoft Access

Рет қаралды 1,531

Күн бұрын

Пікірлер: 27

@seanmackenziedataengineering Ай бұрын

Make sure to check out the next episode *Web Data Entry with MS Access* kzbin.info/www/bejne/i32UeYChjMaZprM and the details on how to extend it onto the web: kzbin.info/www/bejne/gWLFZp2rZZ2LeMk

@mikeaxworthy 8 күн бұрын

Great video Sean. If I could get this up and running, it would be so cool. Unfortunately I was not able to get it to work. I think it all starts from having Microsoft 365 32-bit which required me to install older versions of the libraries. From all my searchings for solutions to the errors (Python is all new to me), I think I saw somewhere that Streamlit (except for older versions) is not designed for 32-bit. I have 64-bit Microsoft 365 on my laptop and may start again there and see how far I get.

@seanmackenziedataengineering 7 күн бұрын

Yeah, you will need to install the version of the MS Access "runtime" that works with Streamlit. That installs the required ODBC/OLE drivers needed to work remotely with Access like this. It may or may not conflict with whatever version of Office you're currently running. Actually I didn't know that about Streamlit, so thanks for sharing that with everyone.

@mikeaxworthy 7 күн бұрын

@@seanmackenziedataengineering Sean, I went on a box that had neither 64-bit or 32-bit Office on it. Started with the Access Database Engine for 64-bit, continued with Python 64-bit and the rest of the installs all worked flawlessly. I've got my database showing up in the web browser. Now onto your next videos on this topic. Thank you so much for putting up these videos!

@seanmackenziedataengineering 6 күн бұрын

@@mikeaxworthy Nice! Good work :wrench:

@wowjunjun Ай бұрын

Thank you so much for the video! it is changing my life, I am learning a new skill and I love it. Sir, cold you please upload the access file from this video so I can download and use it？thank you again!!!

@seanmackenziedataengineering Ай бұрын

I'm glad it worked for you! Check back later today for these files at mackenziemackenzie.com/downloads

@simonmaersk 2 ай бұрын

This is cool, thanks for sharing! I have a few questions; If your Access database file has a password, how do you handle that? Second question; is it possible to use this to create web forms where users can add and edit data? We have an ERP system that is all Access based, but it would be cool if I could create a web app that allows our suppliers to login and update their information in our system so we don't have to.

@seanmackenziedataengineering 2 ай бұрын

Glad you liked it! You can put the password in the connection string as a key value pair maybe after "DBQ=" + access_db + ";PWD=ABC123" For your second question, you absolutely can have forms where users can do data entry and edit data. I'll be demonstrating exactly that in the next few videos in this series. Stay tuned!

@simonmaersk 2 ай бұрын

@@seanmackenziedataengineering Awesome, looking forward to the next wideos!

@akokohjoel9854 2 ай бұрын

I am looking for to it too

@seanmackenziedataengineering 2 ай бұрын

@@akokohjoel9854 See today's video kzbin.info/www/bejne/i32UeYChjMaZprM

@Chowchow_t 2 ай бұрын

🎉 love it! This is localhost tho, wondering if this can be published to the outside world while data is real time?

@seanmackenziedataengineering 2 ай бұрын

You can easily publish this to the outside world, or just on your LAN, and many people can use it at the same time. There are some methods but you might check out ngrok that will give you an app address on the web connected to your localhost 8501. I will demonstrate this on a future episode. Very slick.

@Chowchow_t 2 ай бұрын

@@seanmackenziedataengineering "ngrok" noted!! i will check it out. Thanks!!

@agbedometi5940 2 ай бұрын

Hello Prof, thank you for your videos. Please I would like to ask for some information. Why app access We can't get to the hostel. Thanks for replying.

@seanmackenziedataengineering 2 ай бұрын

We're using MS Access + Streamlit to make a web app 🛠