Web Data Entry for Microsoft Access

In this episode in our MS Access playlist, we show how to do a simple data-entry form that runs in the browser and populates the Access database on our computer. Most Access developers all have that one pesky bit of data that they need to collect from users who don't have Access on their workstations, or who are spread out on the internet. We'll use about 30 lines of Python, using Streamlit and ngrok to showcase how easy it is to set up a web data entry form for Microsoft Access. 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....
#msaccess #python #streamlit #ngrok

[@seanmackenziedataengineering]

Make sure to check out the previous episode to get started with Streamlit kzbin.info/www/bejne/ipOkdnZ6iZx5fLc and the next episode showing two ways to get your app on the web: kzbin.info/www/bejne/gWLFZp2rZZ2LeMk Also download the files to play with: mackenziemackenzie.com/downloads

[@manishkashikar9154]

Mr. Sean MacKenzie thank you so much. What a nice way of teaching!

[@seanmackenziedataengineering]

You're very welcome!

[@romeus2012]

¡ Magnifico maestro !, a estudiar se ha dicho Saludos desde Lima-Perú Gracias

[@seanmackenziedataengineering]

¡Pronto habrá más información! Me alegro de que hayas disfrutado del vídeo.

[@jamesmartinez9069]

Muchas gracias ingeniero, es invaluable su conocimiento sobre el tema

[@seanmackenziedataengineering]

Me alegro que te haya ayudado

[@simonmaersk]

Thank you for the video!

[@seanmackenziedataengineering]

My pleasure!

[@wowjunjun]

Thank you so much for this video, could you explain a little bit more the minute 18:48, I got a little bit lost when you sir added the run_ngrok_app, I didnt see that coming, but thank you so much!

[@seanmackenziedataengineering]

ngrok is just a little free app that has one cool feature: reverse proxy. That means it gives you a real web address out in "the wild" and connects that to some port on your computer; in this case 8501 which is running streamlit. I'll be doing a video on installing it. Docker is another tech that allows you to run different kinds of apps on your computer in "containers". You can google it, get the installer and take all the defaults during installation. Then you can easily get ngrok and run it using the commands I showed in the video. That will connect the outside world to your streamlit MS Acces app!

[@Muslimtap]

Waw that an eye 👀 opening tutorial sir thanks. I wan to know if Python flask framework can also be used to to build something like this.

[@seanmackenziedataengineering]

You can indeed! You can see how I do a similar project with an Excel sheet here: kzbin.info/www/bejne/f4XcoXqAjblnbs0 Flask will be more geared toward high scalable production, but it is a little harder.

[@simonmaersk]

I don't want to get ahead of myself here, but is it possible to have the form open up an existing record? I am trying to build a web app with user logins where users can edit a specific record only, based on who logs in. Does this sound realistic and doable?

[@seanmackenziedataengineering]

That will be pretty easy with streamlit. I'll be doing edits in an upcoming episode 🛠

[@simonmaersk]

@@seanmackenziedataengineering Thank you, looking forward to it!

[@bumpersmith]

For the drop down's, can you load them with data that is in the Access database like the Access comboboxes instead of filling them with statice text?

[@seanmackenziedataengineering]

You bet, please watch the previous episode where I demonstrate this: kzbin.info/www/bejne/ipOkdnZ6iZx5fLc Watch how I load the selectboxes using a query on Access.

[@ayeikh1867]

hello my operating system windows 64 bit my ms office 32 bit--already engine 32 bit my python 64 bit What do I need to do to be able to connect to the Access database via sreamlit?. I have a lot of trouble downloading Docker on my device because the download requirements do not match my device. I tried downloading an old version but it did not work.

[@seanmackenziedataengineering]

You don't have to use Docker, you can use method #1 from this week's video: kzbin.info/www/bejne/gWLFZp2rZZ2LeMk Also make sure to watch the preceding video as it talks about bit versions and some prerequisites: kzbin.info/www/bejne/ipOkdnZ6iZx5fLc

[@tuffley2175]

Very valuable if you know python My hand are tied and permission is denied Too old to open the can of worms too Thank you 🐍 Only thing left is to CRY 😢

[@seanmackenziedataengineering]

Don't cry :-) you can try it! Similar in complexity to VBA (easier in some ways)

[@SAMYTAHER]

√√√

[@seanmackenziedataengineering]

🛠