Access reserved word gotcha

[bender]

published clients page to my local server to test making it DSN-less,
and finally found out why some of the update pages did not work.

seems the word "container" is not a reserved word on their server
(access 2000), but it is on mine (XP).

This little bit of nonsense wasted me more time than I want to admit.

now i can get some sleep.....zzzzzzzzzzzzzzzzzzzzz

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

 

[MD Websunlimited]

An you're sharing this with us because?

 

[Bob Lehmann]

Could be different ODBC and/or Jet versions on the computers. Here's a list
for future reference....
http://www.aspfaq.com/show.asp?id=2080

Bob Lehmann

 

[Bob Lehmann]

Maybe he just didn't have any product "Announcements" to clutter the group
with, so he chose to be helpful instead.

Bob Lehmann

 

[Kevin Spencer]

You can enclose database object names in square brackets to prevent this
error. Example:

SELECT [container] FROM [date]

The square brackets indicate that the token represnts a database object
rather than the reserved word. This can also be used when you have column
names wiht spaces in them as in:

SELECT [this column name has spaces] FROM [this table name has spaces]

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[bender]

Could be different ODBC and/or Jet versions on the computers. Here's a list
for future reference....
http://www.aspfaq.com/show.asp?id=2080

Bob Lehmann

+++++++++++++++++++++++++++++++++++++++++++++++++++
Thanks, I'll look into it. Nice reference page to add to my bookmarks.

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

 

[MD Websunlimited]

An this helped you how?

 

[Bob Lehmann]

It didn't help me at all.

But, bender's post resulted in *some* feedback that could be helpful.

Bob Lehmann

 

[MD Websunlimited]

Okay, but Bender never asked a question.

But you're right Bob.

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Stop Spam Email Mining from your web pages with SpamStopper
http://www.websunlimited.com/order/product/SpamStopper/spam_stopper_help_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

 

[Bob Lehmann]

Bender,

In the future, please phrase your answers in the form of a question.

Alex Trebek

 

[Guest]

And MD WebsUnlimited, what is your motivation to be posting out here... I am new to this forum but the two previous posts that I came across that you replied to it seemed as though you were selling your product as the solution. Now I don't have a problem with that but that being said I wouldn't get too caught up in forum etique either if you know what I mean. Ptiching ones product doesn't rate high on the forum etique list.

 

[bender]

Bender,

In the future, please phrase your answers in the form of a question.

Alex Trebek

++++++++++++++++++++++++++++++++++++++++++++++++++++
um....
If you publish your web from one server to another and it doesn't work
correctly, should you keep in mind that MS Access XP has more reserved
words than MS Access 2k? Can I buy a vowel? Is J-Bots worth the
money?

Sorry for my posting in non-question form....should have been posted
in my earlier thread "Stop me before I use DSN again!", since it
answered part of my question there.

bender
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

 

[Bob Lehmann]

I was just funnin' with you bender. :>) I don't see any problem with what
you posted.

Bob Lehmann (aka Alex Trebek)

 

[Guest]

Maybe somebody is so desparate for income, they'll take any opportunity to hawk their cheap, am-ature designed terribly supported products. You know how those mom and pop shops are

----- Bob Lehmann wrote: ----

Maybe he just didn't have any product "Announcements" to clutter the grou
with, so he chose to be helpful instead

Bob Lehman

 

[Kevin Spencer]

These are support newsgroups. As such, I think that's about enough flaming
for the week, don't you?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

Maybe somebody is so desparate for income, they'll take any opportunity to

hawk their cheap, am-ature designed terribly supported products. You know
how those mom and pop shops are.