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 Chris Miller 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
That didn't work either. I believe it has something to do with the indexes on the SQL server even though the record no longer exist (I delete it just before I'm trying to insert from the temp table) it still runs into a validation problem. If I remove the Primary Keys and the Relationships...- soujam69
- Post #4
- Forum: Visual Basic (Classic)
-
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)
