mike55 Posted April 22, 2006 Posted April 22, 2006 Hi all I have the following update statement for a MS Access database, and I am getting an error with it. "UPDATE HerdDetails SET HerdNumber = '12345ABC', HerdOwner = 'adsf', Address1 = 'adje', Address2 = 'jaf', Town = ' nadsf', State/County = 'oasdfn', Country = 1, Phone = 012313, Email = '0203123@Adsf.com' WHERE Reference = 1;" Would appreciate it if anyone spotted the error could point it out. Table name and column names and types are correct. Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
*Experts* Nerseus Posted April 22, 2006 *Experts* Posted April 22, 2006 Whenever you have tables or columns named with reserved words or invalid characters, you need to wrap the names in brackets. In your case, the column State/County will need to be [state/County]. It won't hurt to wrap them all, though you may just want to wrap those that are necessary. -ner Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.