Unanswered: Connecting to Access from Web page using workgroup info file
Here is a somewhat bizarre problem with no obvious solution.
I wrote and administer a Web-based work order management system for a college. Users inside the computer department must log onto the system with a username and password to perform most system tasks, while others at the school can perform a few basic functions without logging in.
The system uses Active Server Pages to move data into a Microsoft Access data base. A single file includes the code to open the connection to the data base. This file is included in all pages that need to reach the data base. The system uses a DSN to store the connection information.
Practically all computer department staff and outside employees can use the system normally. But one computer belonging to a manager in the computer department cannot log onto the protected parts of the system. The page that begins the password validation process cannot open the connection to the data base. The following error message displays when someone tries to log onto the protected areas of the system from this computer:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
This is silly. The workgroup information is exactly where it should be. Since other computers can get into the system, the exclusive open part is also incorrect.
Since the problem only occurs on a single computer, it makes sense that the problem might have something to do with the Windows configuration on that computer.
I have looked in various places on the Net but have not found any clues to the problem. Any help would be appreciated.
Chattanooga State Technical Community College
Chattanooga, TN, USA