Results 1 to 9 of 9

Thread: How do you make it so a databse will not open exclusively

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Resolved How do you make it so a databse will not open exclusively

    Can anyone tell me how to do this. I'm getting an error on my webpage and the problem is i can't seem to query because the database opens exclusively
    Last edited by noycwild; Dec 16th, 2005 at 03:54 PM.

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: How do you make it so a databse will not open exclusively

    What kind of database is it?

    If it is Access, don't open the same database from elsewhere (eg: in Access).

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Re: How do you make it so a databse will not open exclusively

    Quote Originally Posted by si_the_geek
    What kind of database is it?

    If it is Access, don't open the same database from elsewhere (eg: in Access).
    It is an access database, I was just wondering if there was an option of some sort to set this database to be able to open it nonexclusively. Or is it because its an access database, there is no way to open it nonexclusively?

  4. #4
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: How do you make it so a databse will not open exclusively

    I could be wrong, but I think that IIS needs to open the database exclusively - which means you cannot use the database elsewhere while the page(s) that work with it are in use.

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How do you make it so a databse will not open exclusively

    Quote Originally Posted by si_the_geek
    I could be wrong, but I think that IIS needs to open the database exclusively - which means you cannot use the database elsewhere while the page(s) that work with it are in use.
    I believe you are correct. Other databases such as Oracle or SQL Server will release the exclusivity once the page itself has been loaded, however, MS Access is not the flexible.

  6. #6

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Re: How do you make it so a databse will not open exclusively

    Quote Originally Posted by si_the_geek
    I could be wrong, but I think that IIS needs to open the database exclusively - which means you cannot use the database elsewhere while the page(s) that work with it are in use.
    Maybe I'm a noob but does that mean that the web host needs to set that up or can I do that myself?

  7. #7
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: How do you make it so a databse will not open exclusively

    IIS does it automatically, and I don't think you can change that behaviour.

  8. #8

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Re: How do you make it so a databse will not open exclusively

    Quote Originally Posted by si_the_geek
    IIS does it automatically, and I don't think you can change that behaviour.
    Thanks for the information much appreciated.

  9. #9

    Thread Starter
    Member
    Join Date
    Jan 2005
    Posts
    53

    Re: How do you make it so a databse will not open exclusively

    Thanks for the help....it did end up being the webhost side making the problem.

Posting Permissions

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



Click Here to Expand Forum to Full Width