Access reserved word gotcha

B

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."
 
B

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
 
K

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.
 
B

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
Click to expand...
+++++++++++++++++++++++++++++++++++++++++++++++++++
Thanks, I'll look into it. Nice reference page to add to my bookmarks.

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

Bob Lehmann

It didn't help me at all.

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

Bob Lehmann
 
B

Bob Lehmann

Bender,

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

Alex Trebek
 
M

Marsh Heller

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.
 
B

bender

Bender,

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

Alex Trebek
Click to expand...
++++++++++++++++++++++++++++++++++++++++++++++++++++
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."
 
B

Bob Lehmann

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

Bob Lehmann (aka Alex Trebek)
 
M

Mom

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
 
K

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.

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