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?
AccessLevelID (primary key)
LoginID (primary key)
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!
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.