HTTPS "updateable query" error

I have an Order page that updates an MS-Access database.

I am getting the following error:

Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.

However, I only get the error when the page runs under HTTPS.

One solution is to just run it under HTTP but I'd prefer not to.


A stripped-down version of my code is:

Const cDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Set objADO = Server.CreateObject("ADODB.Connection")
objADO.Open cDSN & Server.MapPath("test.mdb")
objADO.Execute("UPDATE Orders SET Note = 'TEST' WHERE ID = 1")
objADO.Close
Set objADO = Nothing


The didn't find either of the following helpful:

http://www.aspfaq.com/show.asp?id=2062 Article #2062
How do I solve 'Operation must use an updateable query' errors?
"This is almost always a permissions issue."

http://support.microsoft.com/default.aspx/kb/175168
PRB: ASP Returns 'Operation Must Use an Updateable Query' Error

Can anyone advise? Thanks in advance.

Re: HTTPS "updateable query" error

McKirahan wrote:
> I have an Order page that updates an MS-Access database.
>
> I am getting the following error:
>
> Microsoft JET Database Engine error '80004005'
> Operation must use an updateable query.
>
What is the user context when using https? That user has to have read/write
authority to the folder containing the database.
--
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.