Can't open Access database connection

Discussion in 'Databases' started by chriscanali, Jun 28, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. chriscanali

    chriscanali

    Whenever I try to open a connection to an access database with .open (in a Web Application) I always get the following:

    The Microsoft Jet database engine cannot open the file 'C:\...mdb'. It is already opened exclusively by another user, or you need permission to view its data.

    I just have the default "admin" for the database name, with no password. I don't have Access open. I can't figure it out, any help would be much appreciated.
     
    chriscanali, Jun 28, 2005
    #1
  2. chriscanali

    chriscanali

    When I said above "admin" is the database name, I meant the user ID
     
    chriscanali, Jun 28, 2005
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    this is usually an error produced by MS Access client.

    Do you have other pages that has the DB opened exclusively?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 28, 2005
    #3
  4. chriscanali

    chriscanali

    I figured it out. I had to go to the Security tab in the properties for the .mdb and for the folder it was in and add a user with ServerName\User (with full rights). The Server Name being my local machine name, and User is ASPNET by default.
     
    chriscanali, Jun 28, 2005
    #4
  5. chriscanali

    chriscanali

    BTW, in case anyone is trying to do this too and doesn't have a Security tab in the properties window, go to Folder Options in Windows Explorer, and uncheck "Use simple file sharing (Recommended)".
     
    chriscanali, Jun 28, 2005
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page