I have an access database that I have written a Python script for in order to update the data in the database. It currently functions fine but the Python scripts need to be in a folder in the same directory as the existing Access database. Is there a way to package the Python code into the Access database so the user doesn't need to worry about the extra updater folder and make sure it is in the proper spot? Ideally, there would be no additional files and the script would be fully contained within the existing Access database. I saw something online about putting the contents of the Python scripts into a table in the DB, then writing some sort of VBA code to create a TEMP file that contains the code that was in the Access table and finally running the TEMP Python script. I haven't really tried much; I'm just looking for ideas atp. Continue reading...
