Re: Authority to Mapics Files from PC programs

   Hrishikesh,

   Under normal circumstanc= es, no mapics user has authority to mapics
   files.  The as400 handles t= he security of the file by using adopted
   authority support.. What this mean= s, that when the user is accessing the
   files outside of the 400, they don't= have any access to the file..

   Your options woul= d be to add the users to the file authority (Not
   recommended) or you could = attach your ODBC connection with a different
   user id than the user that is = working..

   You could use AMAPICS profile, but th= at would open the file up to more
   than just read.

   Mic= hael Franchino
   Custom Systems Corporation
   http://www.c= ussys.com
   (973) 726-0202 X214 (Phone)
   (973)&nbsp= ;726-4552 (Fax)
   -----mapics-l-= bounces+michael.franchino=cussys.com@xxxxxxxxxxxx wrote:
   -----

   </F= ONT>To: MAPICS-L@xxxxxxxxxxxx
   From: "hrishikesh kotwal" <hdkotwal@xxx= mail.com>
   Sent by: mapics-l-bounces+michael.franchino=cussys.com@xx= drange.com
   Date: 06/06/2003 10:09AM
   Subject: Authority to Mapics File= s from PC programs

   Hi all:

   We have started = developing many PC programs that access Mapics Files via
   ODBC & S= QL. The users who use these PC programs are also Mapics Users.
   Theref= ore, they already have atleast 'Read' access to Popular Mapics
   files.= But when the same users are trying to access the files from PC
   progr= ams, they get the following error message:

   *** START ***

   = General SQL error.

   [IBM][Client Access Express ODBC Driver [32-= bit][DB2/400 SQL]SQL0551 -
   Not
   authorized to object ITEMASA in AMFLIB= Q type *FILE.

   ***END***

   How to deal with this problem?<= BR>
   Thanks in advance.

   Regards,

   H= rishikesh Kotwal

   --------------------------------------= --------------------------------

   It's magic. It's a whole new wor= ld. It's the Windows XP experience.
   ____________   _________________________   __________
   This is the MAPICS ERP System Discussion = (MAPICS-L) mailing list
   To post a message email: MAPICS-L@xxxxxxxxxxxx<B= R>To subscribe,
   unsubscribe, or change list options,
   visit: http://l= ists.midrange.com/mailman/listinfo/mapics-l
   or email: MAPICS-L-reque= st@xxxxxxxxxxxx
   Before posting, please take a moment to review the archi= ves
   at h= ttp://archive.midrange.com/mapics-l.