Reserved Word "Position"

[Jessard]

Hi All,

I am writing a .NET app that accesses an access View. The view has a table
column called 'Position'. When i try and right an UpdateCommand string for
this using this column I am greeted with a 'Syntax error in Update
statement.' when attempting the update. I take that field out and the update
works. I am assuming Position is a reserved word. I have even tried
changing the name of the column in the View to something other than Position
with no luck.

What am i missing here?

Thanks in advance,
Jesse

[cody]

Position is not a reserved word. Show us your code so we can show you where
your syntax error really is.

--
cody

Freeware Tools, Games and Humour
http://www.deutronium.de.vu || http://www.deutronium.tk
"Jessard" <Je*****@discussions.microsoft.com> schrieb im Newsbeitrag
news:0F**********************************@microsof t.com...

Hi All,

I am writing a .NET app that accesses an access View. The view has a table column called 'Position'. When i try and right an UpdateCommand string for this using this column I am greeted with a 'Syntax error in Update
statement.' when attempting the update. I take that field out and the update works. I am assuming Position is a reserved word. I have even tried
changing the name of the column in the View to something other than Position with no luck.

What am i missing here?

Thanks in advance,
Jesse

[Nick Malik]

you are missing the code for us to look at so we can help you.

Please post the statement that is giving you difficulty, and the statement
that works, and the error message...

--- Nick

"Jessard" <Je*****@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com...

Hi All,

I am writing a .NET app that accesses an access View. The view has a table column called 'Position'. When i try and right an UpdateCommand string for this using this column I am greeted with a 'Syntax error in Update
statement.' when attempting the update. I take that field out and the update works. I am assuming Position is a reserved word. I have even tried
changing the name of the column in the View to something other than Position with no luck.

What am i missing here?

Thanks in advance,
Jesse