MS Access 2007 User permissions
in [General]
|
Prev: strMail Query!
Next: Remote desktop software
From: Citipool on 13 May 2010 15:18 Totally understandable! Interesting concept! "Arvin Meyer [MVP]" wrote: > 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: Arvin Meyer [MVP] on 13 May 2010 20:18
Excuse me, Mr. Kemp, once again you are completely wrong. There is no different security on an adp than on an mdb. Security has not been "killed" for MDB's. The no format ACCDB has no equivalent in an ADP because there haven't been any changes or improvements since Access 2003. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf(a)gmail.com> wrote in message news:33efe858-1325-4cbc-9094-fbee84271cf6(a)a27g2000prj.googlegroups.com... 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? |