Parameter <name> specified where a table name is required. (Error 3216)

  • Article

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

  PARAMETERS Param1 Text;

  INSERT INTO Param1

  SELECT *

  FROM Customers;

  Param1

is a text parameter, but the INSERT INTO statement expects a table name.

Change the parameter type from Text to TableID, and then try the operation again.