Execute an AS400 command

[madhouse]

Does anyone know how to go about executing an AS400 command from within Access. Currently I maintain a database of user profiles that exist on an AS400. When a member of staff leaves the company I manually delete the user profile from the AS400 system. I thought it would be great if I could have a button on a form within my Access database that when clicked would then execute the command DLTUSRPRF on the AS400.

Any ideas??

 

[The_Doc_Man]

Look up help topic Shell. See if that leads you anywhere.

 

[Pat Hartman]

You can create a pass-through query to execute a stored procedure. Then execute the pass-through query in your click event.

You can also link to the tables on the AS400 and they you would be able to use bound forms or Access queries to manipulate data.

 

[madhouse]

The_Doc_Man - I had a look at the Shell function but that only seems to apply to Windows programs where you specify the pathname to the application.

Pat Hartman - I'm not sure how a pass through to a stored procedure is going to accomplish what I'm looking for. You see the DLTUSRPRF command not only deletes the user profile on the AS400 it also deletes any objects owned by that user. So I need to specifically use the DLTUSRPRF command and pass through the name of user profile to be deleted.