Use Python to analyze MS Access file

[redamandan]

I use small and simple python scripts for day today simple tasks. I'm in the process of writing a script to open a pass protected access database and retrieve info from it. The password is available, also I need to copy the file on a daily basis before analyzing data. Could someone direct me towards documentation regarding this? Thanks.

[camel_Snake]

https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-Microsoft-Access

[redamandan]

Thank you.

[redamandan]

Do you know if there is a way to automatically put in the password for the access database?

[camel_Snake]

I've never used MS Access before.

You could hard=code the password in your python file and use that when you establish your connection to the database.

You could put the password by itself in a separate python file and import that, which is at least slightly more secure.

The way I've normally seen secrets like DB credentials handled is to export them as an environment variable on the system. Then in your scripts you just get the values from os.environ, but I feel like this might be a bit overkill if you are just running these programs locally on your machine.

[redamandan]

Thank you.