RE: Accessing I5 data from Microsoft Access

Mark
Thank you...that sounds like it will work

Mary

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S. Waterbury
Sent: Tuesday, September 08, 2009 2:46 PM
To: Midrange Systems Technical Discussion
Subject: Re: Accessing I5 data from Microsoft Access

Hi, Mary:

I suggest you keep all of your "master files" as DB2/400 database tables
and views (physical files and logical files, in OS/400-speak), and then
use techniques such as ODBC access to DB2 databases on OS/400 from
within Microsoft Office applications (Word, Excel, Access, etc.) to give
your users the nice-looking PC-based user interfaces that they are
apparently used to.

To learn more about this approach, I suggest you get one of these books:
http://mcpressonline.stores.yahoo.net/5041.html
or
http://mcpressonline.stores.yahoo.net/5072.html

Hope that helps,

Mark S. Waterbury

Mary E Mallazzo wrote:
Good morning



We are an I5 shop running V5r1 and are looking into integrating our master
files from the I5 with a Microsoft Access 2003 data base. We would prefer

to

be able to have "live" data not just file transfers. What would be the

best

approach. We have been thinking that IFS might be a road to go down, but
would that still necessitate some form of transfer of data?



Thanks



Mary