Re: Access reports File is Read Only

Kirk,

Does your system has any exit point security program installed? Here at my
shop I do control ODBC access using an exit point, so does not matter the
user's auth. level.

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, Jan 4, 2010 at 7:53 PM, Kirk Goins <kgoins@xxxxxxxxxxx> wrote:

So *PUBLIC with *ALL is not good enough?


Graap, Kenneth wrote:

Even though the ODBC connection is configured for READ/WRITE, the user

making the connection will still require Update Authority to the file ...

GRTOBJAUT


Kenneth
Kenneth E. Graap
http://www.linkedin.com/in/kennethgraap


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:

midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kirk Goins

Sent: Monday, January 04, 2010 2:20 PM
To: Midrange Systems Technical Discussion
Subject: Access reports File is Read Only

I have a client trying to get an ODBC connection working. They already

have at least 1 connection working propoerly from the server in question and
the i5.

The i5 is at 6.1 Access can 'read' the data just fine. For testing

*public has full permissions on the file and the library.

Anyone have a place I can look to see why they are getting an error

saying the the file is Read Only when they try to write data? The ODBC
connection is set to Read/Write.

Thanks

--
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 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.