[AccessD] Read-Only Linked ODBC Table?

Powell, David (BBM) david.powell at bbm.wapl.com.au
Sun May 11 19:15:15 CDT 2003


Ron,

Just set permissions on the table as select only.  Or Set up a guest
account which has select permissions on this table and link via that
account.  We use this method quite successfully.


Regards

David


-----Original Message-----
From: Ron Allen [mailto:chizotz at charter.net] 
Sent: Saturday, 10 May 2003 3:08 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Read-Only Linked ODBC Table?


Is it possible to use a linked table from a SQL Server 
2000 db in an Acc97 front end and make the linked table 
read only? Seems to me that should be pretty simple to do, 
but I can't seem to find any information on how to do it. 
I'm hoping I'm just missing something obvious.

Thanks,

Ron
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege 
intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering 
the message to the intended recipient, be advised that you have received this message in error and that any dissemination, 
copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein.  
If you have received this message in error please notify the sender immediately and delete the message

Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation.
Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests:
Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, 
Kobe Alumina Associates (Australia) Pty Limited 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.



More information about the AccessD mailing list