Modify MS Access using iSeries RPGLE
Home > IT Answers > AS/400 > Modify MS Access using iSeries RPGLE
Wkozerski
20 pts.
0
Q:
Modify MS Access using iSeries RPGLE
iSeries RPG programming, RPGLE, Microsoft Access
I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?
ASKED: Jul 16 2009  5:01 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24570 pts.
0
A:
 RATE THIS ANSWER
-1
Click to Vote:
  •   0
  •  -1
  • AddThis Social Bookmark Button
Someone more knowledgeable than I may have an asnwer - they may need to know
the versions of Access and your AS/400. -- here's what I know.

I haven't found a request from the AS/400 side.
The newer versions of Access tables can be addressed through an ODBC connection.

I've connected from early versions of access to the AS/400- and I'm sure this still works.
install client access on the machine
create an ODBC data source to the AS/400
create remote tables -- that are 400 tables
use/update the tables from within access

Phil
Last Answered: Jul 17 2009  1:51 PM GMT by Philpl1jb   24570 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

KatanaBeach   60 pts.  |   Jul 20 2009  2:01PM GMT

magic software has a product called UniPaas. You can download a free version which allows ODBC as well as Mysql native. With Unipaas you can access both access and as400 tables as you wish. write the programming you need for interfacing the 2 systems and then buy a runtime license(@300 a seat). If you are familiar with the old RPG cycle you will have no trouble coming up to speed with this RAD tool. I can help you with the as400 odbc setup. Create odbc for access table as well. It’s an awesome development environment. Magic software is an IBM Partner. Check is out at <a href="http://magicsoftware.com" title="http://magicsoftware. " target="_blank">magicsoftware.com</a>. Without a RAD tool it will be difficult to accomplish without exporting/importing data back and forth between the 2 systems via flat files. With Client access you could accomplish this. You can create the transfer members and record Macros to automatically transfer and run PC or AS400 programs to comsume them and shield the user from the details.

 

WM   340 pts.  |   Aug 15 2009  1:16AM GMT

You should be able to do this without any problems. MS Office can be integrated with the AS400. You have been able to access data from the AS400 for a long time now. I have personally used ODBC and some other type of connection which I can remember at this time. But someone else should be able to point you in the right direction here.

 
0