SQL Update not working (1 Viewer)

[exaccess]

DoCmd.RunSQL "UPDATE [" & dest & "] SET [Association] '=' [" & Associate & "];"

This SQL statement causes trouble. I tried many variations but none worked. Here the dest is a variable containing the tablename, Association is the name of a column of dest and Associate is a variable containing the data to be stored in all table records. Please help.

 

[JHB]

DoCmd.RunSQL "UPDATE [" & dest & "] SET [Association] '=' [" & Associate & "];"

This SQL statement causes trouble.

If Association is text then:
"UPDATE [" & dest & "] SET [Association] ='" & Associate & "'"
If number then:
"UPDATE [" & dest & "] SET [Association] =" & Associate & "

 

[exaccess]

If Association is text then:
"UPDATE [" & dest & "] SET [Association] ='" & Associate & "'"
If number then:
"UPDATE [" & dest & "] SET [Association] =" & Associate & "

Works like charm, thank you

 

[The_Doc_Man]

You DO realize that your UPDATE updated EVERY RECORD in the destination? You have no WHERE clause so it is an unconstrained update.

If that is what you wanted, or if you simplified it for discussion, then no problem.

 

[exaccess]

Yes that is what I wanted. This table is not normalized. It is an old aplication.

 

[JHB]

Works like charm, thank you

You're welcome.