Easysoft ODBC-ODBC Bridge
Why do I get "Could not find file '(unknown)'" errors using Microsoft Access ODBC driver?
This problem usually occurs because the Microsoft Access MDB file specified in the ODBC data source cannot be found, but it can also be due to permissions.
In ODBC Data Source Administrator on the Windows Machine, open the Microsoft Access System DSN you are using with the Easysoft ODBC-ODBC Bridge. The name of the MDB file should be shown (select the MDB path if you can't read all of it). Does the file exist? Was it on a mapped drive that is no longer mapped?
If the file exists, you should check the following:
- The permissions on the file. The file needs to be readable/writable by the user your ODBC-ODBC Bridge client logs on as, i.e., the value of the LogonUser attribute in your DSN.
- If the MDB file is on a mapped drive, check that the LogonUser is the same person who mapped the network drive. E.g. if user XXX is interactively logged into the Windows server and maps drive H from a network share, no user other than XXX will have access to the mapped drive.
- Is the MDB file linked to a table in another MDB file on a network drive? If so, see the previous point.
- Make sure the System environment variable TEMP is assigned to an existing directory and one which the LogonUser has access to.
To do this, select the Advanced tab in Control Panel > System Properties. Choose Environment Variables. Select the Environment Variable Temp from the System Variables list. If it does not point to an existing directory, change it. Use the OK button to Save your changes and exit the dialogs.
- Make sure LogonUser has permission to create temporary files in the same directory as the MDB file.
- Does another process or user have the MDB file open?
You may also see error "80004005 in Active Server Pages and Microsoft Data Access Components". Check all of the above, plus:
- Does the account that Microsoft Internet Information Server is using have the correct Windows permissions for a file-based database or for the directory that contains the file. IIS usually runs under the IUSR account.
- Is the MDB file marked as Exclusive?
- The error may be caused by a delegation issue. Check the IIS authentication method.
Applies To
-
Products
- Easysoft ODBC-ODBC Bridge
-
Databases
Knowledge Base Feedback