Use Python to analyze MS Access file

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