Solved

Simple Tbl update

Posted on 2014-01-08
3
308 Views
Last Modified: 2014-01-08
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
Comment
Question by:sidwelle
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
If id is numeric, remove the single quotes surrounding the 2.
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
You also need to remove the comma:

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

Open in new window

0
 

Author Closing Comment

by:sidwelle
Comment Utility
Thanks, it was the quotes .
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This is about my first experience with programming Arduino.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now