INSERT INTO SYNTAX ERROR

[Airpan]

I looked at my old post regarding this as I had a syntax issue once before, but alas, they are not the same.
I get the following error:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
line 28
Line 28 is the SQL:

oConn.Execute("INSERT INTO cust_logins (CustID,USERNAME,PASSWORD,CustName,email) VALUES ("& frmcustid &",'"& frmcustuser &"','"& frmcustpass &"','"& frmcustname &"','"& frmcustemail &"')")

I ran the following in access:

INSERT INTO cust_logins ( CustID, USERNAME, [PASSWORD], CustName, email )
VALUES (6060, 'george', 'geroge', 'George', 'g2g.com');

and it successfully inserted the information. Things are breaking this week - not good.

~E

 

[gmmastros]

oConn.Execute("INSERT INTO cust_logins (CustID,USERNAME,[!][[/!]PASSWORD[!]][/!],CustName,email) VALUES ("& frmcustid &",'"& frmcustuser &"','"& frmcustpass &"','"& frmcustname &"','"& frmcustemail &"')")

Looks like you missed the square brackets.

-George

"the screen with the little boxes in the window." - Moron

 

[Airpan]

Thanks.) It worked.

~E