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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update AS400 table from MS Access db

Status
Not open for further replies.
chainedtodesk

chainedtodesk

Programmer
Feb 26, 2003
112
US
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
 
Status
Not open for further replies.

Similar threads

Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
296
Vary88
Vary88
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
293
acoronel
acoronel
brk1221
  • Locked
  • Question
ODBC connection from Windows to IBM Informix
Replies
3
Views
399
genomon
genomon
ghcrazy8
  • Locked
  • Question
Error when processing Cube from MS Access
Replies
0
Views
60
ghcrazy8
ghcrazy8
josmi
  • Locked
  • Question
How to design a fact table to keep track of active dimensions?
Replies
7
Views
123
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top