Query Issue

Tech-Archive recommends: Fix windows errors by optimizing your registry



The query below gets the error....

"Query1 is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long."

Any ideas what is wrong? The field names and table names are right I have
checked many times.

UPDATE JERICHOSCHEDULE1 SET ['ROWID'] = 7, ['EVENTORG'] = 'Zion UCC',
EVENTORGLINK = 'http://www.zionucc.org', EVENTTITLE = 'Contemporary
Service', EVENTDESC = 'Jericho is very excited to play this event as some of
our band members have long standing relationships with this church. ',
EVENTDATE = 6/11/2006, EVENTSTARTTIME = '8:30AM', EVENTCITY = 'Sheboygan',
EVENTSTATE = 'WI', EVENTADDRESS = '1125 N. 6th St', EVENTORGLINKMAP =
'http://maps.google.com/maps?oi=map&q=1125+N+6th+St,+Sheboygan,+WI',
['EVENTSTATUS'] = 'CONFIRMED'
WHERE (([`ROWID`]=7));


--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com




.



Relevant Pages

  • Re: Problem linking to SQL tables in Access
    ... Index names may also "include invalid ... characters or punctuation too long" ... The SQL database is from our billing system - NDCLytec 2006 ...
    (microsoft.public.access.externaldata)
  • Re: Languages which syntax use minimal punctuation?
    ... What languages use very few punctuation characters in their syntax? ... Anyway, you actually said not that it was harder to "write a parser", ...
    (comp.programming)
  • RE: Post Code UK Structure Verification
    ... Dim invalid As Boolean ... ' Validate inner code ..... ... Notepad is used because copying from ... Sort to bring to the top records with too many characters ...
    (microsoft.public.excel.programming)
  • Re: [PHP] One last try at this!
    ... Jim Lucas wrote: ... "Invalid Characters" So $result now contains the value 'Invalid Characters'. ... At one point he mentioned changing ValidateString() to return false on an error. ...
    (php.general)
  • Re: Punctuation question
    ... My characters have dialogue the way I want them to ... and I try to make then speak as I ... I found what I call "teener texting" stories. ... wrong about not needing good punctuation. ...
    (sci.med.transcription)