I am using Microsoft Access.
When i open the connection with the following way it works...

***
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\books.mdb;" & _
"Persist Security Info=False"
***

when i open it following way, it generate the error that i mentioned in my
previous message.

***
conn.open "FileDsn=Books.Dsn"
***

regards,
Mobeen.

>you have not mentioned what RDBMS you are using.
>Check the data Types of both front end and back end i.e. the data type you are trying to save and the data type expected by backend.