MS Access 2007 User permissions
in [General]
|
Prev: strMail Query!
Next: Remote desktop software
From: Sorting in a Graph on 12 May 2010 10:59 How can I restrict some users accessing specific forms/tables? Since 2007 removed user level security; how can 2007 handle this?
From: Arvin Meyer [MVP] on 12 May 2010 12:21 It cannot be done for tables. For forms you can roll your own security by integrating with Windows login username. But since the users can get to the table that would store this information, it isn't 100% foolproof. The alternative is to code each form with specific permissions for each user. To get the Windows login credentials, see: http://www.mvps.org/access/api/api0008.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Sorting in a Graph" <SortinginaGraph(a)discussions.microsoft.com> wrote in message news:7266CCEE-B9DD-49C8-A0CD-3DC9FB2AB1C2(a)microsoft.com... > How can I restrict some users accessing specific forms/tables? Since 2007 > removed user level security; how can 2007 handle this?
From: Citipool on 12 May 2010 15:53 Arvin, Would you suggest creating a form to act as Login form then use Dev's code under OnClick property for the Username text box? would that be sufficient enough? or is there another way to implement it? Thanks:) "Arvin Meyer [MVP]" wrote: > It cannot be done for tables. For forms you can roll your own security by > integrating with Windows login username. But since the users can get to the > table that would store this information, it isn't 100% foolproof. The > alternative is to code each form with specific permissions for each user. > > To get the Windows login credentials, see: > > http://www.mvps.org/access/api/api0008.htm > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.accessmvp.com > http://www.mvps.org/access > > > "Sorting in a Graph" <SortinginaGraph(a)discussions.microsoft.com> wrote in > message news:7266CCEE-B9DD-49C8-A0CD-3DC9FB2AB1C2(a)microsoft.com... > > How can I restrict some users accessing specific forms/tables? Since 2007 > > removed user level security; how can 2007 handle this? > > > . >
From: Arvin Meyer [MVP] on 13 May 2010 09:11 I would use a Login button under the text box. That gives you a bit more flexibility with the code. Remember, like a lock, this is security only for honest people who aren't trying to break it. It provides no more real security than a veil can hide the face of a beautiful woman. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Citipool" <Citipool(a)discussions.microsoft.com> wrote in message news:69CFC919-4EF8-4338-899C-0F8D98696944(a)microsoft.com... > Arvin, > > Would you suggest creating a form to act as Login form then use Dev's code > under OnClick property for the Username text box? would that be sufficient > enough? or is there another way to implement it? > > Thanks:) > > "Arvin Meyer [MVP]" wrote: > >> It cannot be done for tables. For forms you can roll your own security by >> integrating with Windows login username. But since the users can get to >> the >> table that would store this information, it isn't 100% foolproof. The >> alternative is to code each form with specific permissions for each user. >> >> To get the Windows login credentials, see: >> >> http://www.mvps.org/access/api/api0008.htm >> -- >> Arvin Meyer, MCP, MVP >> http://www.datastrat.com >> http://www.accessmvp.com >> http://www.mvps.org/access >> >> >> "Sorting in a Graph" <SortinginaGraph(a)discussions.microsoft.com> wrote in >> message news:7266CCEE-B9DD-49C8-A0CD-3DC9FB2AB1C2(a)microsoft.com... >> > How can I restrict some users accessing specific forms/tables? Since >> > 2007 >> > removed user level security; how can 2007 handle this? >> >> >> . >>
From: a a r o n . k e m p f on 13 May 2010 10:16
Access Data Projects can restrict permissions to tables just perfectly that's why they killed ULS.. because ADP security is sooooo vastly superior On May 12, 7:59 am, Sorting in a Graph <SortinginaGr...(a)discussions.microsoft.com> wrote: > How can I restrict some users accessing specific forms/tables? Since 2007 > removed user level security; how can 2007 handle this? |