Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
can't append all the records in the query or ODBC--call failed
I've got an issue trying to do an INSERT INTO command from Access 2003 to a SQL server 2000 Database. All the 'temp' tables are Access tables and All others are SQL tables. The SQL tables have Primary keys and are link to each other one way or another as well. If I remove the keys and links...- soujam69
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
can't append all the records in the query
I've got an issue trying to do an INSERT INTO command from Access 2003 to a SQL server 2000 Database. All the 'temp' tables are Access tables and All others are SQL tables. If I used the db.excute with dbfailerror I get an ODBC--Failed error. If I use the following DoCmd.RunSQL I get the...- soujam69
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
