Re: SYS21 - Client Access question -- SYSTEM21

The way we handle the file overwrite issue here is to make the ODBC
connection read only.
Greg
----- Original Message -----
From: "Michael Berman" <berman@pacific.net.au>
To: <jbausers-l@midrange.com>
Sent: Monday, July 15, 2002 8:39 AM
Subject: FW: SYS21 - Client Access question


> Neil,
> It has been a long time since I visited that area.
> Check out the User Exit program options on the line descriptions(?).
>
> I remember writing a quick CLP that was a MY User Exit Program... and
> prevented access to ANYONE doing an Upload to the AS/400.
> It logged attempts and sent messages if anyone tried it.  There was an IBM
> Security red book from the early/mid 90's that covers it very well.
>
> While we are on the topic, I hate giving users access to query, because
they
> can overwrite database files.  How can you prevent that?
>
>
> Regards
>
> Michael
>
> -----Original Message-----
> From: jbausers-l-admin@midrange.com
[mailto:jbausers-l-admin@midrange.com]On
> Behalf Of Neil Thursby
> Sent: Monday, 15 July 2002 11:00 PM
> To: jbausers-l@midrange.com
> Subject: RE: SYS21 - Client Access question
>
> Thanks, but we have lots of Excel users who use the "From AS/400"
> facility, I just want to hide the "To AS/400" button.
>
> Neil.
>
>
>
> -----Original Message-----
> From: Wood, Steve [mailto:swood@georgiacrown.com]
> Sent: Monday 15 July 2002 13:30
> To: 'jbausers-l@midrange.com'
> Subject: RE: SYS21 - Client Access question
>
>
>         Neil,
>
>                 You can go to the tools add ins/Plug-ins section on
> Excel
> and De-select the Transfer Data from an AS/400 which will then remove
> the
> option from the tool bar.
>
>
>
> Stephen J Wood.
> Information Systems
> Georgia Crown Distributing
>
>  -----Original Message-----
> From:   Neil Thursby [mailto:neil.thursby@fone-logistics.co.uk]
> Sent:   Monday, July 15, 2002 4:53 AM
> To:     jbausers-l@midrange.com
> Subject:        SYS21 -  Client Access question
>
> We are upgrading our PC's to CA Express v5.1.0.   A new icon then
> appears in Excel - "Transfer data to AS400".  Does anyone know of a
> simple way of disabling or hiding this feature.  I don't mind the
> Transfer From AS400 icon, but I'd rather the "transfer to" button wasn't
> there at all
>
> Thanks in advance,
>
> Neil.
>
> _____________________________________________________________________
> This transmission and any attachments are confidential and are intended
> solely for the named addressee (s). If you are not the addressee, please
> do
> not read, copy, use or disclose this transmission and please notify us
> immediately by telephone on
> +44 (0) 1670 594848 or by reply.  Please then delete this transmission
> from
> your system.
>
> Although we have taken steps to ensure that this email and attachments
> are
> free from viruses, we advise that in keeping with good computing
> practice
> the recipient must ensure that they in fact are virus free.
>
> No contracts may be concluded on behalf of Fone Logistics LTD by means
> of
> email communications.
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/jbausers-l.
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/jbausers-l.
>
>
> _____________________________________________________________________
> This transmission and any attachments are confidential and are intended
> solely for the named addressee (s). If you are not the addressee, please
> do not read, copy, use or disclose this transmission and please notify
> us immediately by telephone on
> +44 (0) 1670 594848 or by reply.  Please then delete this transmission
> from your system.
>
> Although we have taken steps to ensure that this email and attachments
> are free from viruses, we advise that in keeping with good computing
> practice the recipient must ensure that they in fact are virus free.
>
> No contracts may be concluded on behalf of Fone Logistics LTD by means
> of email communications.
>
> _____________________________________________________________________
> This transmission and any attachments are confidential and are intended
> solely for the named addressee (s). If you are not the addressee, please
do
> not read, copy, use or disclose this transmission and please notify us
> immediately by telephone on
> +44 (0) 1670 594848 or by reply.  Please then delete this transmission
from
> your system.
>
> Although we have taken steps to ensure that this email and attachments are
> free from viruses, we advise that in keeping with good computing practice
> the recipient must ensure that they in fact are virus free.
>
> No contracts may be concluded on behalf of Fone Logistics LTD by means of
> email communications.
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/jbausers-l.
>
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/jbausers-l.
>
>