is there anyway to update an as400 table with info from an MS Access db. i read several posts on lots of sites saying journaling needed to be turned on and that the table on the 400 could not have a keyed field i have done all of this but still receive the #7800 error everytime i try to post the data form the database to this table. i created the table so its currently blank and it was made specifically for pushing the data from the DB to it. is there anyting else i can try? is there a different connection that is needed to perform this? is it a different ODBC connection than im trying??? thanks