I thought about this before, but hadn't tried it. I think this will work well enough for what I want. It limits it so that they only have access to the fields they need. I created a pass-through select query to bring it in, so they can't even edit the data without writing an update query in SQL, which they do not know how to do.
Thanks, Toby ----- Original Message ----- From: "Eric Douglas" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 23, 2005 2:24 PM Subject: RE: [AccessDevelopers] Re: Access Security If it is a SQL table, then you could create a view in SQL, and link to that instead of linking directly to the table. > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly > Sent: Tuesday, August 23, 2005 2:04 PM > To: [email protected] > Subject: Re: [AccessDevelopers] Re: Access Security > > Hal, > > Thanks for the reply. > > However, I don't need different front ends. I don't have > different levels of users. I am creating one database for > one group of users (i.e., HR), and if possible, I don't want > them to even be able to read certain fields from the same > table that they need data out of. Apparently Access' > security cannot handle this. > > Basically HR wants to be able to see Name, Address, Phone, > SSN, Status, plus a couple of their own fields that are > stored in a separate Access table, linked by EmpId. They > should only be able to edit the couple of fields stored in > the Access table. And I don't want them to be able to see > other fields in the SQL like PayRate. > > As long as I don't need to allow them to build any queries, I > suppose I could disable the Database Window. That may be the > easiest solution. > > Or maybe the answer is instead of linking to the SQL table, > copy over all the needed data into an Access table, and > create a way to update the table to contain live data. > > Thanks, > Toby > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, August 23, 2005 1:39 PM > Subject: Re: [AccessDevelopers] Re: Access Security > > > > I know this may sound insane, but why not do two different > front-ends, one > > with all tables for the power suer and another with just > the plain data... > > > > Hal McGee > > Engineering Data Manager > > Group Engineering - Process and Compliance > > Seating Products Group > > B/E Aerospace > > Winston-Salem, NC > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > Yahoo! Groups Links > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > <font face=arial size=-1><a > href="http://us.ard.yahoo.com/SIG=12hoet2v8/M=362335.6886445.7 > 839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124838249 > /A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/to > pics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http: > //groups.yahoo.com/">In low income neighborhoods, 84% do not > own computers. At Network for Good, help bridge the Digital > Divide!</a>.</font> > -------------------------------------------------------------- > ------~-> > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > > Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hodk68u/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124845740/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
