Make sure to check out the next episode *Web Data Entry with MS Access* ua-cam.com/video/UL1HMkWafpQ/v-deo.html and the details on how to extend it onto the web: ua-cam.com/video/K1b5ju08XBg/v-deo.html
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.
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.
@@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!
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!!!
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.
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.
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.
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!
Make sure to check out the next episode *Web Data Entry with MS Access* ua-cam.com/video/UL1HMkWafpQ/v-deo.html and the details on how to extend it onto the web: ua-cam.com/video/K1b5ju08XBg/v-deo.html
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.
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.
@@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!
@@mikeaxworthy Nice! Good work :wrench:
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!!!
I'm glad it worked for you! Check back later today for these files at mackenziemackenzie.com/downloads
Great, excellent
Go for it!
thank you very much sir for this share
Most welcome!
🎉 love it! This is localhost tho, wondering if this can be published to the outside world while data is real time?
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.
@@seanmackenziedataengineering "ngrok" noted!! i will check it out. Thanks!!
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.
We're using MS Access + Streamlit to make a web app 🛠
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.
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!
@@seanmackenziedataengineering Awesome, looking forward to the next wideos!
I am looking for to it too
@@akokohjoel9854 See today's video ua-cam.com/video/UL1HMkWafpQ/v-deo.html
good work
i will try it
but can i run this code and my access file is still open?
Yes, you can run it at the same time as your other users.
@@seanmackenziedataengineering i love python❤️
@@ayeikh1867 me too!