DataLink & Access Stored Queries

2.91K viewsDataLink
0

Recently, one of our users was having trouble connecting to a stored query in an Access database via DataLink. A “Too Few Parameters” error message was returned.

We discovered that if the Access query utilized double-quotes, the system ODBC driver could not find the table names correctly.

Once single quotes were utilized, Quantrix was able to connect to the table fine.

FYI…

-Mike