Skip to main content
S
sjacobs748
Participant
July 21, 2006
Answered

Invalid Field Names

  • July 21, 2006
  • 1 reply
  • 370 views
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
This topic has been closed for replies.
Correct answer The_ScareCrow
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

1 reply

T
The_ScareCrowCorrect answer
Inspiring
July 21, 2006
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
S
sjacobs748Author
Participant
July 21, 2006
Much obliged.

Seth
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices