No database specified in connection string or IN clause. (Error 3321)

  • Article

The Microsoft Access database engine is unable to connect to an external ISAM database because you have not specified the name of the database to connect to. When connecting to an external source of data, you must specify a database name.

Possible causes:

  • The connection string in the FROM clause of the SELECT statement is missing the parameter, DATABASE=.
  • The IN clause of the SELECT statement includes a database type argument (indicating to select the data from an external database) but it is missing a database name argument.