How do I connect to MS Access database in JMP 10

[azeemers]

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!

[Reeza]

JMP has it's own forum, please post the question there.

https://www.jmp.com/forum/

[azeemers]

Thanks!