How to Use Streamlit with Microsoft Access

In this episode, we are introducing Streamlit with Microsoft Access, and what better way to smoke test this free technology than to make an interactive web report on our MS Access data? We'll go through the entire setup process and in about 20 minutes of coding we'll have a whole web app running, using our Access data with dropdown filters and checkboxes. Our web report just scratches the surface of what you can do in a short amount of time with Streamlit; once you get a feel for it, you'll realize how to extend your Access app in many different ways. Need a data entry interface for a few of your users that don't/can't have Access on their computers? Easy. Just make a Streamlit interface. Let's go!
Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker:
buy.billzone.c...
Check out my easy time entry system for your business:
system.billzon...
Join me on Patreon!
/ mackenziedataengineering
Check out some tech (and support my channel!):
www.amazon.ca/...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#streamlit #msaccess #python

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

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]

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]

@@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]

@@mikeaxworthy Nice! Good work :wrench:

[@HRazaJ]

thank you very much sir for this share

[@seanmackenziedataengineering]

Most welcome!

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

[@SAMYTAHER]

Great, excellent

[@seanmackenziedataengineering]

Go for it!

[@Chowchow_t]

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

[@seanmackenziedataengineering]

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]

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

[@simonmaersk]

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]

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]

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

[@akokohjoel9854]

I am looking for to it too

[@seanmackenziedataengineering]

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

[@agbedometi5940]

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]

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

[@kayronpozo]

Hi, I have run into a problem, I get the follwoing error message: sqlalchemy.exc.InterfaceError: (pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)') Notsure how to fix it, any ideas?

[@seanmackenziedataengineering]

You probably need to install the ODBC driver for Access, which gets installed when you install the Access Runtime redistributable (you can google it)

[@ayeikh1867]

good work i will try it but can i run this code and my access file is still open?

[@seanmackenziedataengineering]

Yes, you can run it at the same time as your other users.

[@ayeikh1867]

@@seanmackenziedataengineering i love python❤️

[@seanmackenziedataengineering]

@@ayeikh1867 me too!