Re: Client - Server

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>]

Raul:

I think you could develop iSeries (server-side) stored procedures to 
access or update only those selected files, and change your VB front-end 
to CALL the stored procedure via ODBC. 

The stored procedure *PGM can adopt owner authority so it has access to 
those files. Give the program *PUBLIC *EXCLUDE and grant authority to 
*USE the program only to those users who are authorized to run this VB 
front-end client/server application to update those files.  These stored 
procedures could also be designed to take care of any commitment control 
issues (somehow know when to issue a COMMIT).

That way, users cannot access or update those files directly through 
ODBC (e.g. via Excel).

Regards,

Mark S. Waterbury