Modify MS Access using iSeries RPGLE

20 pts.
Tags:
iSeries RPG programming
Microsoft Access
RPGLE
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • KatanaBeach
    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 magicsoftware.com. 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.
    115 pointsBadges:
    report
  • WM
    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.
    460 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following