Updateable Query CreateQuerydef

  • Thread starter Thread starter blinton25
  • Start date Start date
B

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?
 
Does [Input Table] have a primary key defined? It's not updatable unless it
does.
 
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)



blinton25 said:
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?
Click to expand...


.
Click to expand...
 
Hi,

I forgot to relink my tables after changing the primary
key. Once I did this the query ran ok.

Thanks again.
-----Original Message-----
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)



blinton25 said:
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?
Click to expand...


.
Click to expand...
.
Click to expand...
 
Back
Top