Accessing DB2 OS/390 via MS Access / DB2 Client ODBC

[ks01]

Hello ...

We have DB2 OS/390 tables linked in Microsoft Access via the DB2 Client (ODBC). We used to be able to view the table/view in Access and modify the value in a field, but now, we are no longer able to. It's like Access will not allow us to modify the field values. We do have ALTER authority on the view/tables so I know it's not a DB2 permissions issue. My db2cli.ini file shows the following:

[MVS4DBP1]
PWD=
UID=
SCHEMALIST="'DBA4','RCX1',CURRENT SQLID,'Q','DBA1'"
TABLETYPE='VIEW'
PATCH2=1,3,6,12
PATCH1=131072
LOBMAXCOLUMNSIZE=1048575
LONGDATACOMPAT=1
DESCRIPTION=OCE Production System
DBALIAS=MVS4DBP1

Can someone let me know what I'm doing wrong? We recently got new computers so I'm thinking that something was not installed or not installed the way it was before.

Thank you.

 

[manmaria]

Are you getting an error? or you are not able to connect to db2?

May be try installing the free AQT(Advanced Query Tool) tool from here

http://www.querytool.com/

 

[ks01]

No, I am receiving no errors. In the past, I was able to tab to a field on the datasheet and change a value just by highlighting it and over typing it. Now, the field is locked so when I highlight the value, I cannot over type.

 

[blom0344]

This may not be relevant, but did you switch from Access97 to Access2000? (when you got new hardware)
Working with combination of DB2 with Access97 never posed any problems, but Access2000 and linked tables just do not work correctly together...

Ties Blom
Information analyst

 

[ks01]

Ties Blom ...

Hi!

Yes, we did upgrade from Access 2000 to Access 2003.

It worked fine for us with Acess 2000 but we cannot update rows from Access now.

Kent