-
Dec 16th, 2005, 09:43 AM
#1
Thread Starter
Member
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.
-
Dec 16th, 2005, 10:15 AM
#2
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).
-
Dec 16th, 2005, 10:20 AM
#3
Thread Starter
Member
Re: How do you make it so a databse will not open exclusively
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?
-
Dec 16th, 2005, 10:26 AM
#4
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.
-
Dec 16th, 2005, 10:28 AM
#5
Re: How do you make it so a databse will not open exclusively
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.
-
Dec 16th, 2005, 10:30 AM
#6
Thread Starter
Member
Re: How do you make it so a databse will not open exclusively
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?
-
Dec 16th, 2005, 10:36 AM
#7
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.
-
Dec 16th, 2005, 10:41 AM
#8
Thread Starter
Member
Re: How do you make it so a databse will not open exclusively
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.
-
Dec 16th, 2005, 03:55 PM
#9
Thread Starter
Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|