MartyConnelly
martyconnelly at shaw.ca
Thu Jul 15 23:50:06 CDT 2004
Well if you were the owner through mdw you could, everyone else would have to go through a query. This assumes the mdw is crackable. Rocky Smolin - Beach Access Software wrote: >Marty: > >Why couldn't they just go directly into the back end and open the table in >design view? > >Rocky > > >----- Original Message ----- >From: "MartyConnelly" <martyconnelly at shaw.ca> >To: "Access Developers discussion and problem solving" ><accessd at databaseadvisors.com> >Sent: Thursday, July 15, 2004 6:40 PM >Subject: Re: [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 >> >> >> >>-- >>_______________________________________________ >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> > > > -- Marty Connelly Victoria, B.C. Canada