Pulling data from MS Access 97 database uisng JMP 12 or higher
Aug 20, 2019 9:10 AM(1576 views)
I am working on updating a script to that was written in JMP 7 and pulls data from Access97. No issue to get it to work with JMP 11 version, but when I try with JMP 12 there are issues with extracting the tables from Access 97 database. There are three different errors received. I don't have experience pulling information from Access database to JMP. I need to see if I can get this script working with a newer version of JMP 12 or higher with minimum effort. Any help or tips for direction would be appreciated. Errors: [Microsoft][ODBC Microsoft Access Driver] Cannot open a database created with a previous version of your application. Unable to connect to database Unable to open table: SMSPlus in database: MS Access Database
I am not familiar with those error messages. You didn't happen to change from 32-bit JMP in JMP 11, to 64-bit in JMP 12, did you? If so, you would have a driver bitness mismatch that would prevent JMP from working with the Access ODBC driver.