Solved

Simple Tbl update

Posted on 2014-01-08
3
310 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
ID: 39766189
If id is numeric, remove the single quotes surrounding the 2.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39766199
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
ID: 39766827
Thanks, it was the quotes .
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

910 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

19 Experts available now in Live!

Get 1:1 Help Now