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 > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hpfa5ev/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124839492/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
