inetserver asp db: Websites & Access Databases -- inetserver asp db

Re: Websites & Access Databases

RSteph
9/21/2006 8:58:02 AM

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.

[quoted text, click to view]

Re: Websites & Access Databases

James Jones
9/21/2006 10:26:34 AM

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

[quoted text, click to view]

Re: Websites & Access Databases

RSteph
9/21/2006 11:25:02 AM

Thanks for the help, I've got things set up and working.

[quoted text, click to view]

Re: Websites & Access Databases

Bob Barrows [MVP]
9/21/2006 11:50:50 AM

[quoted text, click to view]

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.

Re: Websites & Access Databases

Patrice
9/21/2006 5:30:35 PM

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" <jamisonxxxburrousxxx08xxx@xxxinsightbbxxx.xxxcomxxx> a écrit
dans le message de news: euwhiIZ3GHA.3508@TK2MSFTNGP03.phx.gbl...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the inetserver asp db group.