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