Make sure to check out the next episode *Web Data Entry with MS Access* th-cam.com/video/UL1HMkWafpQ/w-d-xo.html and the details on how to extend it onto the web: th-cam.com/video/K1b5ju08XBg/w-d-xo.html
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!
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.
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!!!
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.
![[FINALE] มีคนคิดแค้นลักพาตัวเด็กไป🔪หญิงชราใช้ชีวิตตัวเองเข้าแลก👩🦳 #โลกการละคร](http://i.ytimg.com/vi/C_BPHPoZFOg/mqdefault.jpg)
Make sure to check out the next episode *Web Data Entry with MS Access* th-cam.com/video/UL1HMkWafpQ/w-d-xo.html and the details on how to extend it onto the web: th-cam.com/video/K1b5ju08XBg/w-d-xo.html
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 th-cam.com/video/UL1HMkWafpQ/w-d-xo.html
🎉 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!!
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
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 🛠
thank you very much sir for this share
Most welcome!
Great, excellent
Go for it!
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!