How to query Access Linked Tables?

[#1]

Hello,

I try to load a linked table from an Access database and keep getting the error "Tables () referenced in the SQL Query were not found in the database in access or evaluation of 'Table'.. ". The script works fine for the local tables and a local copy of the linked table. I'm using JMP 16. Please help!

Thanks in advance!

fn_GetData = Function( {test},
	New SQL Query(
				Connection(
			"ODBC:DBQ=path\fileName.accdb;
		DefaultDir=path;
		Driver={Microsoft Access Driver (*.mdb, *.accdb)};
		DriverId=25;
		FIL=MS Access;
		FILEDSN=path\filename.dsn;
		MaxBufferSize=2048;
		MaxScanRows=8;
		PageTimeout=5;
		SafeTransactions=0;
		Threads=3;
		UID=admin;
		UserCommitSync=Yes;"
		),
		QueryName( "QueryGetData" ),
		Select(),
		From( Table("tblName", Alias( "t1" ) ) )
	) << Run Foreground;
	Wait( 0.01 );
	dt = Data Table("QueryGetData");
	Wait( 0.01 );
	dt << Show Window( 0 );
);

[#2]

Hi,

Sorry that you have not received a reply yet.

I think this is a difficult one for the JMP Community to help with. It is not clear to me what you are trying to do and what the problem is. I suspect the problem is related to your database or database connection rather than anything related to JMP.

Regards,

Phil