CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Database >> Microsoft Access
Microsoft JET Database Engine error '80004005' Could not use '; file already in use.

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
159
Date Created
Monday, January 9, 2012
This Article Has been Viewed
2282 times
Short Desc
When working with Access Database in web development, you may run into the following issue, if the database is opened in Microsoft Office Access.
Details
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.

Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/ACN.asp, line 6
Recreate Issue
To recreate this issue.

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, it will give this error.
Resolve Issue
To resolve this issue.

After you create the database for the first time, close out of the database within Access, and then open the database back up. This free's the database, and allows for connections to come in.

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

All Topics