Write permissions??

[Cam]

Can anyone help?

I am running asp pages linked to an Access database (2000 file format) on a
web site which works fine, both on the internet and on my local IIS.
My client has downloaded all the files to his laptop and the site falls over
whenever it tries to 'execute' update, delete or insert.
It's like he does not have write permission, but we have checked his
configuration against mine for Access and IIS and can see no difference.
I am running XP Pro SP2 and he is on SP1 - That is the only difference we
can find.
We have checked all the obvious (in my limited knowledge) things like files
are not set to read only etc.

One of the error he gets is "Operation must use an updateable query" but in
every case the query is trying to write direct to a table and I understand
that this error occurs when one tries to update a query with a calculated
field or similar.

Can anyone point me in the right direction?

TIA

Clive Moss

[Bob Barrows [MVP]]

Cam wrote:

Can anyone help?

I am running asp pages linked to an Access database (2000 file
format) on a web site which works fine, both on the internet and on
my local IIS.
My client has downloaded all the files to his laptop and the site
falls over whenever it tries to 'execute' update, delete or insert.
It's like he does not have write permission, but we have checked his
configuration against mine for Access and IIS and can see no
difference.
I am running XP Pro SP2 and he is on SP1 - That is the only
difference we can find.
We have checked all the obvious (in my limited knowledge) things like
files are not set to read only etc.

One of the error he gets is "Operation must use an updateable query"
but in every case the query is trying to write direct to a table and
I understand that this error occurs when one tries to update a query
with a calculated field or similar.

No, that's not the only cause.
http://www.aspfaq.com/show.asp?id=2062

--
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.

[Cam]

That has solved it - it was the folder permissions way up the tree
somewhere.

Thanks, Bob

Clive Moss

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:OQ**************@TK2MSFTNGP02.phx.gbl...

Cam wrote:

Can anyone help?

I am running asp pages linked to an Access database (2000 file
format) on a web site which works fine, both on the internet and on
my local IIS.
My client has downloaded all the files to his laptop and the site
falls over whenever it tries to 'execute' update, delete or insert.
It's like he does not have write permission, but we have checked his
configuration against mine for Access and IIS and can see no
difference.
I am running XP Pro SP2 and he is on SP1 - That is the only
difference we can find.
We have checked all the obvious (in my limited knowledge) things like
files are not set to read only etc.

One of the error he gets is "Operation must use an updateable query"
but in every case the query is trying to write direct to a table and
I understand that this error occurs when one tries to update a query
with a calculated field or similar.

No, that's not the only cause.
http://www.aspfaq.com/show.asp?id=2062

--
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.