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.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124838249/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/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 <*> 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/
