Insert into SQL --> Access

kanikakanika Member Posts: 247
edited 2013-04-23 in SQL General
Hi @ll,

I have a query in access (office professional Plus 2010) and exactly the same query in SQL (Server 2008 R2), if I run it from SQL inserts the data in the table perfectly but if I run it from Access I get the famous "Microsoft Access set 0 fields to Null due to a bug in the type conversion and added 732 records to the table due to key violations, 0 records due to lock violations, and 0 records due to validation rule violations "

I need to know if there is a parameter in the query property to prevent this error, because the code is exactly the same as SQL (I did copy and paste) and SQL works perfectly.

anyway how to run SQL code from Access?

thanks to @ll
Sign In or Register to comment.