Gerald
|
| Posted: 11/20/2002, 4:39 PM |
|
This is really simple .. I don't know why it doesn't work.
I used the Grid and Record Builder to build a page to update one simple user table in a MS Access database (all access permissions given to IUSR).
I get the "error" response when using the page built to add a record (similarly if I want to update a record):
Source: Record LoginInfo1 / Insert Operation
Command Text: INSERT INTO LoginInfo(LoginName, Password, LoginDescription) VALUES ('NewLogin', 'NewPass', 'This is a new user')
Error description: Syntax error in INSERT INTO statement. (Microsoft JET Database Engine)
INSERT INTO LoginInfo(LoginName, Password, LoginDescription) VALUES ('NewLogin', 'NewPass', 'This is a new user')
When I go into Access and execute the SQL statement it works fine (I just need to approve the insert after excuting the SQL).
What do i need to do to make this work?
|
|
|
 |
Gerald
|
| Posted: 11/20/2002, 5:03 PM |
|
Problem with field names ... "Password" field name is problematic!
|
|
|
|
|
