469,270 Members | 1,664 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

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
May 30 '06 #1
2 1296
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.
May 30 '06 #2
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.

May 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by clintonG | last post: by
5 posts views Thread by Stephane | last post: by
2 posts views Thread by Carl Gilbert | last post: by
3 posts views Thread by frekster | last post: by
1 post views Thread by =?Utf-8?B?R2FuZXNoIE11dGh1dmVsdQ==?= | last post: by
1 post views Thread by pauld | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.