ODBC error 80004005 with Live Data, Preview in Browser or direct browsing of file on Windows 2000 system
Issue
Live Data view does not work and previewing file in browser produces following error(s):
| Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't use '(unknown)'; file already in use. |
-or-
| Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. |
Note: This TechNote only applies when using an Access database and Windows 2000 for Web server
Reason
There are two common reasons for this error:
- Windows 2k permissions issue. The account that is accessing the page doesn't have sufficient permissions to lock the database.
- Time-out value needs to be changed for the Access database DSN.
Solution
- To fix the permissions issues, please refer to Microsoft Knowledge Base article 174943 PRB: 80004005 "Couldn't Use '(unknown)'; File Already in Use".
- To change the time-out value for the Access database DSN:
- From the Windows 2000 Start menu, launch the Control Panel by choosing Settings > Control Panel, double click Administrative Tools, then Data Sources (ODBC).
- Click on the System DSN tab
- Highlight the correct DSN and click on the Configure button
- Click the Options button, and change the Page Timeout value to 5000.
This content requires Flash
To view this content, JavaScript must be enabled, and you need the latest version of the Adobe Flash Player.
Download the free Flash Player now!
