DB2 and using Ms Access 2003

[bertkerkhof]

I am using DB2 with EnterpriseOne on a windows 2003 srv.
I hv tried to connect through ODBC connection from Access 2003 to the db2 database. Can connect to database and can connect a table to Access but as soon as the key fields contain text the table in Access shows the values DELETED.
Anyone any idea?

Thks
Bert

 

[jmd0252]

I have not connected access to a db2 table. However do you import it as a "linked table"?

 

[bertkerkhof]

Start MS Access
Select empty database
Select tables in the left window
With right mouse button select Link Table or similar
In dutch it is Tabel koppelen
Adjust File type to ODBC database in lower part of screen
In the window Machine Data Source select database
Then select table.

 

[jmd0252]

check the following web site,,, it is for jde/peoplesoft/oracle users..

http://www.jdelist.com

 

[bertkerkhof]

ok; tks;i am already checking it.