I've just recently gotten into website design. I've got a website useing .asp
pages, and currently one page is pulling in information from a database to
display on the page. However I run into a problem where, if I have Access
open, to say add more data to a table, or add new tables/forms/etc. then the
page won't load saying that the file is already in use. Anyone know how to
fix this?
there is no way to fix this that i know of. if the database is open,. then u
must close it, then reload the ASP page.
it seems that i mite have seen an option somewhere in past that allowed you
to open it and load it in a ASP page at same time (what ur tryin to
do)....but im not sure on that.
Hope this helps.
James Jones
"RSteph"
news:DD56DA91-A914-40E0-AE35-CE4139B12779@microsoft.com...
> I've just recently gotten into website design. I've got a website useing
> .asp
> pages, and currently one page is pulling in information from a database to
> display on the page. However I run into a problem where, if I have Access
> open, to say add more data to a table, or add new tables/forms/etc. then
> the
> page won't load saying that the file is already in use. Anyone know how to
> fix this?
Likely the exclusive mode option. Note though that some operations are AFAIK
still requiring exclusive mode even if the default is shared mode...
--
Patrice
"James Jones"
dans le message de news: euwhiIZ3GHA.3508@TK2MSFTNGP03.phx.gbl...
> there is no way to fix this that i know of. if the database is open,. then
> u
> must close it, then reload the ASP page.
>
>
> it seems that i mite have seen an option somewhere in past that allowed
> you
> to open it and load it in a ASP page at same time (what ur tryin to
> do)....but im not sure on that.
>
>
>
> Hope this helps.
>
>
> James Jones
>
>
>
>
>
> "RSteph"
> news:DD56DA91-A914-40E0-AE35-CE4139B12779@microsoft.com...
>> I've just recently gotten into website design. I've got a website useing
>> .asp
>> pages, and currently one page is pulling in information from a database
>> to
>> display on the page. However I run into a problem where, if I have Access
>> open, to say add more data to a table, or add new tables/forms/etc. then
>> the
>> page won't load saying that the file is already in use. Anyone know how
>> to
>> fix this?
>
>
RSteph wrote:
> I've just recently gotten into website design. I've got a website
> useing .asp pages, and currently one page is pulling in information
> from a database to display on the page. However I run into a problem
> where, if I have Access open, to say add more data to a table, or add
> new tables/forms/etc. then the page won't load saying that the file
> is already in use. Anyone know how to fix this?
All users of the database file need to be able to create, modify and
delete a locking file that has a .ldb extension in the folder that
contains the database file. This means that users need Change/Modify
permissions for the folder, not just the .mdb file. Who the users are
depends on what type of authentication your website is using. If using
Anonymous, then the IUSR_machinename account requires permission for the
folder. Otherwise, all the accounts of the users themselves need the
permissions. See:
http://support.microsoft.com/default.aspx/kb/253604
http://support.microsoft.com/default.aspx/kb/166029
http://support.microsoft.com/kb/253580/EN-US/
Once the permissions are correct, you will be able to have the database
open in Access while running web pages that also use it.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Basically right now I've got a database with one table that holds a list of
events, and various information for the events. I've also got a form to be
used to add events to the database. At some point I will likely add some more
forms, perhaps for attendees to events, personel lists, etc. I'm planning to
a make an interface that allows individuals to add/delete events from the
current table.
I'd like to be able to allow users to do this, while still having the
information available to the website. And/or allow users to access
information from the database, for example via a report, without having it
take down the page that lists upcoming events.
"James Jones" wrote:
> there is no way to fix this that i know of. if the database is open,. then u
> must close it, then reload the ASP page.
>
>
> it seems that i mite have seen an option somewhere in past that allowed you
> to open it and load it in a ASP page at same time (what ur tryin to
> do)....but im not sure on that.
>
>
>
> Hope this helps.
>
>
> James Jones
>
>
>
>
>
> "RSteph"
> news:DD56DA91-A914-40E0-AE35-CE4139B12779@microsoft.com...
> > I've just recently gotten into website design. I've got a website useing
> > .asp
> > pages, and currently one page is pulling in information from a database to
> > display on the page. However I run into a problem where, if I have Access
> > open, to say add more data to a table, or add new tables/forms/etc. then
> > the
> > page won't load saying that the file is already in use. Anyone know how to
> > fix this?
>
>
>
Thanks for the help, I've got things set up and working.
"Bob Barrows [MVP]" wrote:
> RSteph wrote:
> > I've just recently gotten into website design. I've got a website
> > useing .asp pages, and currently one page is pulling in information
> > from a database to display on the page. However I run into a problem
> > where, if I have Access open, to say add more data to a table, or add
> > new tables/forms/etc. then the page won't load saying that the file
> > is already in use. Anyone know how to fix this?
>
> All users of the database file need to be able to create, modify and
> delete a locking file that has a .ldb extension in the folder that
> contains the database file. This means that users need Change/Modify
> permissions for the folder, not just the .mdb file. Who the users are
> depends on what type of authentication your website is using. If using
> Anonymous, then the IUSR_machinename account requires permission for the
> folder. Otherwise, all the accounts of the users themselves need the
> permissions. See:
> http://support.microsoft.com/default.aspx/kb/253604
> http://support.microsoft.com/default.aspx/kb/166029
> http://support.microsoft.com/kb/253580/EN-US/
>
>
> Once the permissions are correct, you will be able to have the database
> open in Access while running web pages that also use it.
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>