[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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 ?
0
sidwelle
Asked:
sidwelle
  • 2
1 Solution
 
mbizupCommented:
If id is numeric, remove the single quotes surrounding the 2.
0
 
mbizupCommented:
You also need to remove the comma:

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

Open in new window

0
 
sidwelleAuthor Commented:
Thanks, it was the quotes .
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now