OLEDB connection problems

[Andrew Thomas]

Im trying to add a new record in my Access Database, ive been using the ODBC drivers, and i get this message:-

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement

I looked on google groups and found that the problem is probably because i need to use an Jet OLEDB provider.

Ive just installed MDAC 2.6.

Im using dreamweaver MX, and normally just connect using the menu database/dsn name, but i need to insert a 'custom connection string' ive tried this but am getting no luck,

Provider=Microsoft.Jet.OLEDB.4.0;UID=xxx;PWD=xxx;

when i click on the text button i get a 404 error code.

am i missing something, or could you tell me what im doing wrong.

thanks

[DaveAtIFG]

This Google search [google.com] returns some possible solutions.

[Andrew Thomas]

Thanks for the link DAVE, I was actually using a reserved word 'DATE' silly me!

However it still dont work, getting the same error, but i will keep looking, its probably some silly thing im doing :)