Create aceess database(MDB) from iseries

0 pts.
Tags:
AS/400
I need to create mdb's from iseries through RPG or CL program. Can somebody give me some information around this. TIA
ASKED: September 19, 2005  4:35 PM
UPDATED: November 11, 2009  7:34 AM

Answer Wiki

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

One possible way:
Create the PF and LF objects on the iSeries, then go into Access and create a new database. Once created, choose File, Get External Data, Link Tables. From the dialog, choose an ODBC object pointed to the iSeries, and select the PF and/or LF objects. This will make the tables visible in the Access database. If the ODBC driver is set correctly, you will be able to report AND DO ANY OTHER FUNCTIONS THE USER IS AUTHORIZED TO including deleting records…(be careful with this!!!) These tables can be used just like any other MS access tables.

Discuss This Question: 1  Reply

 
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
  • TomLiotta
    What do you mean by "Create aceess database" from RPG or CL? Do mean you want to be able run a RPG program and have Access tables appear on a PC somewhere? Or are you just wanting to create Access tables based on existing files on your AS/400? Tom
    125,585 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