How do I connect to MS Access database in JMP 10?

[#1]

Hello,

I can't seem to connect to an MS Access database in JMP 10.  The script below works fine in JMP 9.  The error I get is, "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".  Do I need to use a different driver ID?

Here is my script:

dt = Open Database(

"DSN=MS Access Database;DBQ=T:\Applications\Executables\Temescal Particle Count database.accde;DriverId=22;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;​",

"SELECT [Particle Data].[Tool Number],

[Particle Data].Date,

[Particle Data].[Tool Type],

[Particle Data].[Inner Row Pre Meas],

[Particle Data].[Inner Row Post Meas],

[Particle Data].[Outer Row Pre Meas],

[Particle Data].[Outer Row Post Meas],

[Particle Data].[Control Pre Meas],

[Particle Data].[Control Post Meas],

[Inner Row Post Meas]-[Inner Row Pre Meas]-[Control Post Meas]+[Control Pre Meas] AS RowA_Adders,

[Outer Row Post Meas]-[Outer Row Pre Meas]-[Control Post Meas]+[Control Pre Meas] AS RowB_Adders

FROM [Particle Data]

WHERE ((([Particle Data].[Tool Number])='Temescal 2800-10' Or

([Particle Data].[Tool Number])='Temescal 2800-13' Or

([Particle Data].[Tool Number])='Temescal 2800-14' Or

([Particle Data].[Tool Number])='Temescal 2800-17'))

ORDER BY [Particle Data].[Tool Number], [Particle Data].Date;"

);

Thanks!

[#2 · Accepted solution]

My first guess would be that your MS Access is installed as a 32bit application, and you installed JMP as a 64bit application.  You can not mix bit levels.  You will need to uninstall JMP 10, and reinstall it as a 32 bit application.

[#3]

Thanks Jim!

[#4]

Alternatively, you could install a 64-bit ODBC driver for MS Access.