Hello,

I have the same problem too. I tried to do what you said but it didn't 
work. Can you be more explicit, please?

this is the path to my database:

...
.../wwwroot
.../wwwroot/poll
.../wwwroot/poll/poll.asp
.../wwwroot/poll/db/poll.mdb


and here is the exact error that i have:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an 
updateable query.
/poll/poll.asp, line 74


I think i changed all the configurations of xp yet.
IIS
Local Security Police
Component Services
Computer Management
Shared Folders
Folder attributes
File attributes
Database Security
TCP/IP configuration
Firewall settings


This same aplication works fine in windows 2000.

What am i doing wrong?


Thanks in advance
Elvio




> Hello Mike,

> I've got the same problem. Did you find an answer by now? I know how to 
h> andle databases in ASP -- it's no problem -- but XP prevents every try 
to 
u> pdate.

> Andre

> 
>>  I'm a novice on this platform but am nonetheless testing an existing 
A> > SP/JAVA application utilizing IIS to permit client and server 
operation 
o> > n the same system.  When an attempt is made to update the ACCESS 
d> > atabase, it fails.

> > The error reported is:

> > Error Type:
M> > icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> > Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or 
o> > bject is read-only.
/> > reunion/addreservation.asp, line 95

> > The associated code is:

> >      set objConn =  Server.CreateObject("ADODB.connection")
 > >     objConn.open "DSN=Invite2ReunionDB"

> >      Set objRSreservations = Server.CreateObject("ADODB.recordset")
 > >     ..
 > >     ..
 > >     objRSreservations.Update

> > The last statement creates the error.

> > I have set the file properties to include WRITE, but that was 
apparently 
n> > ot enough.  I looked for attributes in the OBDC/DSN but couldn't 
find 
a> > ny.

> > Any help would be appreciated.
T> > hanks, Mike

hello

I have a serious problem here and i need some help, please.

When i attempt to made an update to an ACCESS database, it fails.

This is a simplified example of path to my database:

.../wwwroot
.../wwwroot/poll
.../wwwroot/poll/poll.asp
.../wwwroot/poll/db/poll.mdb


and here is the exact error that i have:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an 
updateable query.
/poll/poll.asp, line 74

This only occur on Windows XP. I tried that on windows 2000 and it works 
fine.

I think i changed all the configurations of xp yet:
- IIS
- Local Security Police
- Component Services
- Computer Management
- Shared Folders
- Folder attributes
- File attributes
- Database Security
- TCP/IP configuration
- Firewall settings
- ...

I know how to handle databases in ASP, but XP prevents every try to 
update.


What am i doing wrong? Please help me...


Thanks in advance
Elvio

anyone could hepl plz. 
i experience the same problem too, 
i've tried updating using sql statement, recordset, queries/stored 
procedures, change the connection mode, etc .... but it didnt work

You need to change the NTFS file permissions. IUSR_<machinename> needs RW,
and CREATOR/OWNER should have Full Control for the folder, and files in the
folder.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "yohan chandra" <yohan_ch@h...>
Subject: [access_asp] Re: Update failure on Access file under IIS on XP-PRO


: anyone could hepl plz.
: i experience the same problem too,
: i've tried updating using sql statement, recordset, queries/stored
: procedures, change the connection mode, etc .... but it didnt work
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

thx u for the help.
i've moved my database file into shared documents folder and it's work 
well. i think thats the only way to change the permission for winXP pro 
since there's no security option in the properties of NTFS folder in 
winXP PRo.

do you know another way to change the permission ? cause actually i dont 
want to put my database in that folder, it will be difficult to apply the 
path name for the database.

thx in advance
yohan

You can change the NTFS permissions. I have answered this question many
times on this list. Most recently in this thread:

"Re: [access_asp] Re: Accessing an Access XP database from .NET/VB App"

where I posted the answer on 19th Feb 2002



Cheers

Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "yohan chandra" <yohan_ch@h...>
Subject: [access_asp] Re: Update failure on Access file under IIS on XP-PRO


: thx u for the help.
: i've moved my database file into shared documents folder and it's work
: well. i think thats the only way to change the permission for winXP pro
: since there's no security option in the properties of NTFS folder in
: winXP PRo.
:
: do you know another way to change the permission ? cause actually i dont
: want to put my database in that folder, it will be difficult to apply the
: path name for the database.