Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    124

    Unanswered: field name problem: Please help

    I have a two table DB with a relationship created between the AccessLevelID and the AccessLevel fiels (see table description below). I'm having a problem using an OLEDB connection when trying to submit data to the database from a HTML form...I'm using ASP VBScript. I get an Insert Into statement error. After searching for some background on the error, I found that inappropriate field names can cause this error. I don't see where the field names conflict with any reserved words or special characters, but I'm probably missing something. Can anyone help?

    Tbl 1
    AccessLevelID (primary key)
    AccessLevel

    Tbl 2
    LoginID (primary key)
    UserName
    Password
    firstname
    lastname
    address1
    address2
    city
    state
    zip
    phone
    email
    AccessLevel

    Are any of these field names conflict with reserved words? If not, does anyone have any ideas of what else might be giving causing the error? Thanks in advance for any help!
    -Dman100-

  2. #2
    Join Date
    Jan 2004
    Posts
    24

    PASSWORD

    PASSWORD is a jet sql reserverd word.

    I looked in the help files to find the list of reserved words. To find all the reserved words of jet sql, look in the contents, open the jet sql reference, and look under the overview. You'll find the list of reserved words there.

  3. #3
    Join Date
    Jan 2004
    Posts
    124
    That solved the problem. Thank you! I really appreciate your help!
    -Dman100-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •