Table of contents
Collapse the table of content
Expand the table of content

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

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Applies to: Access 2013 | Access 2016

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.

Access for developers forum on MSDN
Access help on
Access help on
Search for specific Access error codes on Bing
Access forums on UtterAccess
Access wiki on UtterAcess
Access developer and VBA programming help center (FMS)
Access posts on StackOverflow

© 2018 Microsoft