For VB6 enterprise & Ms. Access 97
I use SQL to do whatever transaction (add, edit, delete, etc) intercourse with Ms. Access as database.
The transaction failed whenever SQL statement content single quote ( ' ) from user input variables.
Run-time error '-2147217900 (80040e14)':
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing
operator) in query expression 'User_ID = 'KEN' AND Passwd = 'ke'nc".
It should allow ke'nc as my input passwd veriable.