Group:  Microsoft Access ยป microsoft.public.access.internet
Thread: Access data over Web pages

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Access data over Web pages
"Steve Long" <steve_long[ at ]ntlworld.com> 12.09.2006 07:46:21
Hi, I have an access database with a series of .asp pages providing the data
to the web and accepting some data from a web input. In the live scenario
(on my client's web server) this works well. I have, however, tried to set
up a test system on my PC(XP Pro SP2) using IIS and whilst the mechanics
seem to work (it picks up my main .asp page) I always get the error message
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
/DLWGTestBed/MenuPage.asp, line 89
The line in question attempts to write to my database. I have ensured that
the database is NOT read-only, neither are the rest of the files but I
always get this show-stopper. What am I doing wrong? Steve


Re: Access data over Web pages
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 19.09.2006 15:08:03
Maybe a permission problem for the IUSR_Name_or_your_Machine or
IWAM_Name_or_your_Machine accounts. These accounts are those used by IIS.
Try setting to the administrator group to see if this will correct the
problem or give all permission to the guest for the repertory where the
database is located.

The best newsgroup for asking questions about ASP and Access databases is
m.p.inetserver.asp.db .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Steve Long" <steve_long[ at ]ntlworld.com> wrote in message
news:hBtNg.24624$G72.10027[ at ]newsfe3-gui.ntli.net...
[Quoted Text]
> Hi, I have an access database with a series of .asp pages providing the
> data to the web and accepting some data from a web input. In the live
> scenario (on my client's web server) this works well. I have, however,
> tried to set up a test system on my PC(XP Pro SP2) using IIS and whilst
> the mechanics seem to work (it picks up my main .asp page) I always get
> the error message Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> object is read-only.
> /DLWGTestBed/MenuPage.asp, line 89
> The line in question attempts to write to my database. I have ensured that
> the database is NOT read-only, neither are the rest of the files but I
> always get this show-stopper. What am I doing wrong? Steve
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net