RE: ODBC Access

But of course if the user has enough authority on his PC he could always change the ODBC connection
back to read/write.

Just an FYI

Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Brandt
Sent: Monday, July 16, 2007 10:49 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: ODBC Access

There is a tab on the ODBC configuration panel that allows
you to set up on the local ODBC connection as read only. If
the ODBC connection type is set as a "File DSN" in the ODBC
manager, or you are configuring your own based on keywords in
the ODBC DSN file, the keyword CONNTYPE=2 will set read only.
You can modify the DSN though the ODBC control panel icon, or
directly in the DSN which should be located at C:\Program
Files\Common Files\ODBC\Data Sources.

John Brandt
iStudio400.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt Gross
Sent: Monday, July 16, 2007 9:38 AM
To: Post AS-400 System Questions
Subject: ODBC Access

I should have been more specific with my question...

A user, JoeUser, using Access/Excel,etc from his desktop,
wants to access a file on the iSeries called "Financials" to
do some analysis.

How can I limit his ODBC connection to be "Read" only so he
has no ability to modify the file?

Thanks,

Matt
--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.6/902 - Release
Date: 7/15/2007
2:21 PM


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.6/902 - Release
Date: 7/15/2007
2:21 PM


--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.