How to query Access Linked Tables?

SpideyStrange — Sat, 10 Jun 2023 23:50:23 GMT

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 );
);

Re: How to query Access Linked Tables?

Phil_Kay — Tue, 05 Jul 2022 08:45:26 GMT

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

topic How to query Access Linked Tables? in Discussions

How to query Access Linked Tables?

Re: How to query Access Linked Tables?