Avatar of sidwelle
sidwelle
Flag 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 ?
Microsoft AccessVisual Basic.NETProgramming

Avatar of undefined
Last Comment
sidwelle

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mbizup

You also need to remove the comma:

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

Open in new window

sidwelle

ASKER
Thanks, it was the quotes .
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy