Invalid Field Names

Question

I have an Access 2002 table with tble_persons with a field
name Password. If I have a form with a field called password and
try to insert it into the table using the CFINSERT function, I get
the following error message:

The given fieldname "PASSWORD" could not be found in the
table

If I change the fieldname to "xword" or "var_password" it
works.

I haven't found any Dreamweaver, Cold Fusion, or MS Access
documentation that says "Password" is a reserved word. Can anyone
explain why I can't use password in this manner?

Seth

The_ScareCrow · Accepted Answer

The error is actually comming from the database.

The reason for the error is that "password" is a reserved word.

This link is a list of reserved words for ms access

Which I think is strange as "password" is not listed, but it is a reserved word.
Note: You can also do [password]

Ken

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.