jwcolby
jwcolby at colbyconsulting.com
Mon Dec 17 15:52:20 CST 2007
>Then again. Are they really safe? Can't the client just switch to design view in the query and change the type from Snapshot to Dynaset? Assuming you're not using Access 'security'. A lot of that depends on a lot of things like startup values, right click menus enabled, main menu defaults enabled etc. As Drew stated so eloquently, "security is about keeping honest people honest". Chopping off hands is about keeping dishonest people honest. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Monday, December 17, 2007 4:36 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] shutting down LOL2! True, read only queries are 'safe'. I just had a knee-jerk reaction there. Then again. Are they really safe? Can't the client just switch to design view in the query and change the type from Snapshot to Dynaset? Assuming you're not using Access 'security'. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, December 17, 2007 4:31 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] shutting down >As for queries and tables: an application that allows users to view >queries and tables directly does not need an idle time detection process, it need to the rewritten. :-) LOL, well... I can and do make read-only queries and display them to the client. Sometimes viewing data in a tabular format is just useful, and you can set a property for a query to be read-only. The client can use all of the built-in query functionality like sorting on any column (or set of columns), filtering for specific values etc. Sometimes they like that. John W. Colby -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com