Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    13

    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.
    Mike Rogers
    Chattanooga State Technical Community College
    Chattanooga, TN, USA

  2. #2
    Join Date
    May 2003
    Posts
    13

    Smile Problem Solved

    It turned out the user had disabled cookies on his computer. Since the session variables in Active Server Pages require that a cookie be written to the local computer, this caused the problem.

    It still seems weird that we got that particular error, but there you go.
    Mike Rogers
    Chattanooga State Technical Community College
    Chattanooga, TN, USA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •