Reserved Word - Exception ? mdb table.

[Miro]

I created a field in a db called "Password"

If i do that, the Update row command throws an exception error.
If I call the field PWord then it works great.

Is this a reserved word for an access db? or something?
Are there others?

Thanks,

Miro

====exception code
OleDbException was unhandled

Syntax error in INSERT INTO statement.

=====
=======code for updating db
rwUser = dtUser.NewRow()

Debug.WriteLine ("whats the password =" + strPassword)

rwUser("UniqueN umber") = "0001" 'Database is empty at this point,
"0001" for debug purposes.
rwUser("FirstNa me") = strFirstName
rwUser("LastNam e") = strLastName
rwUser("Login") = strLogin
'rwUser("Passwo rd") = "Hello" 'Update line ( below ) fails
'rwUser("Passwo rd") = strPassword 'Update line ( below ) fails
rwUser("PWord") = strPassword 'Does not fail
rwUser("PhoneNu mber") = strPhoneNumber
dtUser.Rows.Add (rwUser)

'Try
daDataAdapter.U pdate(rwUser) 'Will fail if the field is "Password"

========

[Scott M.]

I don't believe it is, but if you are also using this word as a variable
name in your code, the compiler will get confused.
"Miro" <mi******@golde n.netwrote in message
news:e$******** ******@TK2MSFTN GP02.phx.gbl...

>I created a field in a db called "Password"

If i do that, the Update row command throws an exception error.
If I call the field PWord then it works great.

Is this a reserved word for an access db? or something?
Are there others?

Thanks,

Miro

====exception code
OleDbException was unhandled

Syntax error in INSERT INTO statement.

=====
=======code for updating db
rwUser = dtUser.NewRow()

Debug.WriteLine ("whats the password =" + strPassword)

rwUser("UniqueN umber") = "0001" 'Database is empty at this point,
"0001" for debug purposes.
rwUser("FirstNa me") = strFirstName
rwUser("LastNam e") = strLastName
rwUser("Login") = strLogin
'rwUser("Passwo rd") = "Hello" 'Update line ( below ) fails
'rwUser("Passwo rd") = strPassword 'Update line ( below ) fails
rwUser("PWord") = strPassword 'Does not fail
rwUser("PhoneNu mber") = strPhoneNumber
dtUser.Rows.Add (rwUser)

'Try
daDataAdapter.U pdate(rwUser) 'Will fail if the field is "Password"

========

[Cowboy \(Gregory A. Beamer\)]

If you name a column or table using a keyword, surround with []. That is an
indicator to the database that you are using reserved words.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"Miro" <mi******@golde n.netwrote in message
news:e$******** ******@TK2MSFTN GP02.phx.gbl...

>I created a field in a db called "Password"

If i do that, the Update row command throws an exception error.
If I call the field PWord then it works great.

Is this a reserved word for an access db? or something?
Are there others?

Thanks,

Miro

====exception code
OleDbException was unhandled

Syntax error in INSERT INTO statement.

=====
=======code for updating db
rwUser = dtUser.NewRow()

Debug.WriteLine ("whats the password =" + strPassword)

rwUser("UniqueN umber") = "0001" 'Database is empty at this point,
"0001" for debug purposes.
rwUser("FirstNa me") = strFirstName
rwUser("LastNam e") = strLastName
rwUser("Login") = strLogin
'rwUser("Passwo rd") = "Hello" 'Update line ( below ) fails
'rwUser("Passwo rd") = strPassword 'Update line ( below ) fails
rwUser("PWord") = strPassword 'Does not fail
rwUser("PhoneNu mber") = strPhoneNumber
dtUser.Rows.Add (rwUser)

'Try
daDataAdapter.U pdate(rwUser) 'Will fail if the field is "Password"

========