Without the error message it is difficult to say.
Something I often have to check is the type of data.

i.e.
it is good practice to convert the variable into the format the database 
needs:

INSERT INTO ....
VALUES '" & CStr(password) & '"," & CInt(phone) ....

Or you surrounded a number with ' ', the database won't like it.

Hope this helps

Joern