Parameter specified where a database name is required. (Error 3217)

Applies to: Access 2013 | Access 2016

You created a parameter query that specifies an invalid parameter type. The following example produces this error:

PARAMETERS Param1 Text;

SELECT CustomerID
FROM Customers IN Param1;

Param1 is a text parameter, but the FROM clause requires a database parameter. Change the parameter type from Text to Database, and then try the operation again.

See also