Greg Rees

got it working now. I did need to specify the File class, but also needed so much more! I've copied the initial version of my program in case it can be of help to other newbies. The code is in "script.py". The MS Access database is called "Cards_and_Accounts_be_TEST.accdb" and it has a table named "Data_Cards" with fields "Card_Acct_ID", "Expiry", "Hold", "EmailAddr" The database is in the same directory as the python file. classpath is defined for the necessary files. Made a DatabaseBuilder Class...

Hi all. trying to open an MS Access database in python using jpype and Jackcess and am having limited success (ie none at all). Got JVMstarted and seem to be able to get DatabaseBuilder Class assigned in python but I keep getting errors when trying to open an existing database in the python running directory. Database is MS Access 2016 named 'test.accessdb.accdb' Running on Raspberry Pi Debian Stretch Classpath is set as below. File paths are correct. classpath="/home/pi/mnt/LiqN2Dispensing/jar/jackcess-2.2.2.jar:/home/pi/mnt/LiqN2Dispensing/jar/commons-lang-2.6/commons-lang-2.6.jar":/home/pi/mnt/LiqN2Dispensing/jar/commons-logging-1.2/commons-logging-1.2.jar"...