Access to MSsql: Error: -2147217900

General usage of Access to MySQL

Moderator: jr

Access to MSsql: Error: -2147217900

Postby novoplan » Tue Jun 29, 2010 11:18 am

Using MS ACCESS to MSSQL version
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

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

Re: Access to MSsql: Error: -2147217900

Postby jr » Wed Jun 30, 2010 5:59 am


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

Site Admin
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm

Return to General

Who is online

Users browsing this forum: No registered users and 2 guests