Connecting to Mainframe

yeah, I was wondering if anybody could tell me how exactly I would go about getting a report from the mainframe using the Access VBA.

Thanks,
matt

Well, I am not sure, although a know of a Access develoment web site which might be able to help : -

http://www.mvps.org/access/

Hope this is some help.

I connect to a db2 database on the mainframe with DB2 connect on the server and communications server from a Visual Basic program.

I just figured out that I can add the object library EXTRA! (which is actually the client tool we use to connect to the mainframe) but what's really frustrating is that there's no real documentation about how to set an object of type ExtraSession to a current session. Or how even if I can, how am I supposed to get through all the usernames and passwords.

Later,
Matt