Link to home
Create AccountLog in
Avatar of sidwelle
sidwelleFlag for United States of America

asked on

Simple Tbl update

Trying to do a simple update to an access tbl and I get the following error:

In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.

statement:
"UPDATE vendors01 SET VendorName='test', WHERE ID='2'"

ID is the primary key and I a record w/ID = 2 does exist.

What's going on ?
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
You also need to remove the comma:

"UPDATE vendors01 SET VendorName='test'  WHERE ID= 2"

Open in new window

Avatar of sidwelle

ASKER

Thanks, it was the quotes .