dear admin
I try to add a new record into a table with name _users and then when I push the Save Button a msg apears on the screen
Technical information
Error number -2147217900
Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '$value_username'.
URL /a1/_users_add.asp
Solution
code beffore add
'** Insert a record into another table ****
strSQLInsert = "insert into _users (username, password) values ($value_username, $value_password)"
dbConnection.Execute strSQLInsert
BeforeAdd = True
what is your solution
best regards
mdialekt