Re: Accessing I5 data from Microsoft Access -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.