[AccessD] Hiding Back End Design

I came across this today under the Access ORK.You might be able to hide 
the design this way.
http://www.microsoft.com/office/ork/2000/three/65t3_9.htm

Using the RunPermissions Property with User-Level Security
In order for Microsoft Access to display a table or query, it must read 
the design of that table or query. As a result, in order for a user to 
read and display the data in a table or query, that user must also have 
permission to read the design of the table or query.
If you dont want your users to see the design of your table or query, 
you can create a query and set its RunPermissions property to restrict 
their access to this information.
Set it up and test against one of the access reengineering case tools 
like Sparxs or EZDesign.

Rocky Smolin - Beach Access Software wrote:

>One of the great advantages of Access is that the user can work with the
>data apart from the front end app.  It's transparency is a real marketing
>plus.  So I'd like to leave the back end open.  I think it will be
>beneficial.
>
>Rocky
>
>----- Original Message ----- 
>From: "Andy Lacey" <andy at minstersystems.co.uk>
>To: "'Access Developers discussion and problem solving'"
><accessd at databaseadvisors.com>
>Sent: Wednesday, June 23, 2004 11:36 AM
>Subject: RE: [AccessD] Hiding Back End Design
>
>
>  
>
>>I'm going to sound a dissenting voice here. I don't understand why Rocky,
>>who's no doubt sweat blood to develop his vertical app, should in effect
>>give his system away? Because surely that's what he'd be doing? The only
>>    
>>
>way
>  
>
>>doing a development like this makes sense is to get economies of scale by
>>selling lots of copies. Without that incentive vertical apps would never
>>    
>>
>get
>  
>
>>developed at all because, in the main, a single customer can't stand all
>>    
>>
>the
>  
>
>>development costs. And if you're going to put in the graft why shouldn't
>>    
>>
>you
>  
>
>>dream of making money on it, and why should you open yourself to being
>>ripped-off by people who can't be arsed to do the hard work themselves?
>>Sorry, don't understand.
>>
>>-- Andy Lacey
>>http://www.minstersystems.co.uk
>>
>>    
>>
>>>-----Original Message-----
>>>From: accessd-bounces at databaseadvisors.com
>>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>>>DWUTKA at marlow.com
>>>Sent: 23 June 2004 18:30
>>>To: accessd at databaseadvisors.com
>>>Subject: RE: [AccessD] Hiding Back End Design
>>>
>>>
>>>'Open source' should pervade into all areas of the
>>>information age.  Music, programming, videos, etc.
>>>Unfortunately it will take a complete change in humanity's
>>>driving force....the accumulation of wealth.  As long as
>>>people are trying to make a buck, it will be virtually
>>>impossible to get them to do stuff simply for the betterment
>>>of society.
>>>
>>>Drew
>>>
>>>      
>>>
>>-- 
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>    
>>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada