Updateable Query CreateQuerydef

[blinton25]

Hello,

How are you today?


Set Fieldsqry = db.CreateQueryDef("", _
"update [Input Table] set [Input Table]." & DynFN & "
= '" & DynRV & "' where [Input Table]." & DynFN & " is
Null ")

Fieldsqry.Execute (dbOpenDynaset)

However, I gett the following error message:

Operation must use an updateable query.

I have seen this message before for ASP applications where
the permissions weren't set correctly on the database/IIS
guest account, but not sure how this would apply in this
case (ADP, Access, SQL server).

Any ideas on how to resolve this?

 

[Douglas J. Steele]

Does [Input Table] have a primary key defined? It's not updatable unless it
does.

 

[blinton25]

Hello,

It didn't have a Primary Key defined so I created one.
However still getting the same error message.

-----Original Message-----
Does [Input Table] have a primary key defined? It's not updatable unless it
does.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello,

How are you today?


Set Fieldsqry = db.CreateQueryDef("", _
"update [Input Table] set [Input Table]." & DynFN & "
= '" & DynRV & "' where [Input Table]." & DynFN & " is
Null ")

Fieldsqry.Execute (dbOpenDynaset)

However, I gett the following error message:

Operation must use an updateable query.

I have seen this message before for ASP applications where
the permissions weren't set correctly on the database/IIS
guest account, but not sure how this would apply in this
case (ADP, Access, SQL server).

Any ideas on how to resolve this?

.