My guess is that the database is choking on some characters (such as @ in the email address). I don't use ADODB, but there is probably some sort of quoting mechanism to handle special characters.
Comment on Re: Help needed to insert data into MS Access database table........
You are absolutely correct about the @ character. Microsoft Access' query engine will now allow you to use it unless it is either within a single or double quoted string, such as the following:
INSERT INTO foobaric (email,password) VALUES ("foobar@foobaric.com","a
+mbidexterous");