Microsoft Access and Connectivity to IBM Mainframe DB2

[Robert Nusz]

We at OKDPS are wanting to use Microsoft Access 2003 to
develop IN-HOUSE applications that will allow user group
to access data built and stored in a Microsoft Access 2003
database (mdb) as well as connect to an IBM Z/OS Mainframe
computer and its appropriate database stored in IBM DB/2
format as well as possibly IBM VSAM files. Has anyone
attempted these connections, will Microsoft Access 2003
talk to (send data to and from) IBM DB2 and/or IBM VSAM
files if the server that houses Microsoft Access has
access rights to the mainframe. Also, what other products
have to be purchased to allow multiple users on the server
update capabilities to the Microsoft Access 2003.mdb
files. What about licensing issues or executables? I
would like to hear from any person/company that has been
there and done that. Thanks. Robert @ OK-DPS

 

[Larry Linson]

I answered with a link to information on Access 2003 runtime support in
microsoft.public.access.odbcclientserver.

In the future, if you post the same question to more than one newsgroup,
please crosspost (include all the newsgroup names in the header) instead of
multiposting. That keeps answers with the question no matter which newsgroup
is used to view it.

FYI, although most of my paying Access work for the last ten years or so has
been Access clients to various servers, I have not used Access as a client
to mainframe DB2, but know that it is possible. It may require appropriate
"middleware", and from your description, you may already have that.

Larry Linson
Microsoft Access MVP