|
I can have the software installed and working properly on my Win98 Dev. Machine running PWS (Personal Web Server). However, I try using the program on our IIS Server I receive the following error:
[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.
- I updated the MDAC as well as made sure that the IUSR_Machinename account had both the proper NTFS and IIS Permissions.
|
|
|
Make sure you did not also copy the LDB file to your IIS server when you copied your MDB database file. The LDB file is a temporary file that is automatically created by the Microsoft JET engine on an MDB database when it is in use. If you accidentally copy an LDB file from your development machine (or server) to your live site or other server, you could prevent the database from being able to be opened properly. This can happen by uploading an active LDB file from any other source. If you do have an LDB file on the server, you can correct this problem by just deleting the LDB file. If you cannot remove it, you will need to either wait for any active IIS sessions to timeout or you can stop the IIS service. Once that happens, you should be able to delete the LDB file without problem. Once it is deleted, you can resume using the site or restart the IIS service.
|
