Access to MSsql: Error: -2147217900

General usage of Access to MySQL

Moderator: jr

Post Reply
novoplan
Posts: 1
Joined: Tue Jun 29, 2010 11:05 am

Access to MSsql: Error: -2147217900

Post by novoplan »

Using MS ACCESS to MSSQL version 3.0.0.138
access 2000, sqlexpress 2008

creating the table is working fine....but transfering data from access to mssql not.
i think the "INSERT INTO" statement isn't correct.

i changed that manually in the dump file.
but i get an error with auto-numbered fields.....

any idea?

sorry for posting here.. but there isn't a board entry for MSSQL

thanks
jr
Site Admin
Posts: 500
Joined: Sun Mar 26, 2006 12:28 pm

Re: Access to MSsql: Error: -2147217900

Post by jr »

Hi,

Can you send a small sample mdb file that will reproduce the error to info at bullzip dot com?

Regards,
Jacob
Post Reply