When working with an Access Database in web development, you may run into the following issues if the database is opened in Microsoft Office Access.

When developing with Access Database, in your web design projects, you will have to work with the Microsoft Office Access Editor. When this happens, you will come across the following error. This usually only happens when the database is first created.

Create a new database, save it, and connect to it from your ASP Classic or ASP.NET project.
When you try to connect to the database, you'll get this error.

After you create the database for the first time, close Access, then reopen the database. This action frees the database and allows connections to come in.

This problem is a known issue, and I believe it may be by design.