|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Hide Certain Fields wherever they appera to Read-Only UsersHi all,
After reaching page 19 in the newsgroup, I cant go on. Its the eyes you see, they cant see anymore :-) I have ReadOnly users in my db that I do not want to allow to see certain fields wherever they appear, be it in a table, form, query or report. Its to do with medical info that should be kept private from them. Any ideas? Thanks in advance PaddyIrishMan PaddyIrishMan,
Is there any security set p on this database? Do Users have a log-in? What version of Access? Which version may also depend on what is available. OR do you have an Access FE and and SQL Server back-end? As you can see a little more information would help... -- Show quoteHide quoteGina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "PaddyIrishMan" <PaddyIrish***@discussions.microsoft.com> wrote in message news:C136B332-35D8-4B32-AA47-6FE720CE0FC1@microsoft.com... > Hi all, > After reaching page 19 in the newsgroup, I cant go on. Its the eyes you > see, > they cant see anymore :-) > > I have ReadOnly users in my db that I do not want to allow to see certain > fields wherever they appear, be it in a table, form, query or report. Its > to > do with medical info that should be kept private from them. > > Any ideas? > > Thanks in advance > > PaddyIrishMan Sorry about that, I have Access2003, with the database secured. There are 10
people with the same readonly user id and password. The database is stored on a zip drive so no front/back end. Show quoteHide quote "Gina Whipp" wrote: > PaddyIrishMan, > > Is there any security set p on this database? Do Users have a log-in? What > version of Access? Which version may also depend on what is available. OR > do you have an Access FE and and SQL Server back-end? As you can see a > little more information would help... > > -- > Gina Whipp > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "PaddyIrishMan" <PaddyIrish***@discussions.microsoft.com> wrote in message > news:C136B332-35D8-4B32-AA47-6FE720CE0FC1@microsoft.com... > > Hi all, > > After reaching page 19 in the newsgroup, I cant go on. Its the eyes you > > see, > > they cant see anymore :-) > > > > I have ReadOnly users in my db that I do not want to allow to see certain > > fields wherever they appear, be it in a table, form, query or report. Its > > to > > do with medical info that should be kept private from them. > > > > Any ideas? > > > > Thanks in advance > > > > PaddyIrishMan > > > PaddyIrishMan,
I personally have never tried to hide fields based on a log on so here's a stab at what you might try... If CurrentUser = ????? Then Me.SomeField.Visible = True Else Me.SomeField.Visible = False End If -- Show quoteHide quoteGina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "PaddyIrishMan" <PaddyIrish***@discussions.microsoft.com> wrote in message news:07925066-7FFD-43E7-B10C-FF1764F00B91@microsoft.com... > Sorry about that, I have Access2003, with the database secured. There are > 10 > people with the same readonly user id and password. The database is stored > on > a zip drive so no front/back end. > > > "Gina Whipp" wrote: > >> PaddyIrishMan, >> >> Is there any security set p on this database? Do Users have a log-in? >> What >> version of Access? Which version may also depend on what is available. >> OR >> do you have an Access FE and and SQL Server back-end? As you can see a >> little more information would help... >> >> -- >> Gina Whipp >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors >> II >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> "PaddyIrishMan" <PaddyIrish***@discussions.microsoft.com> wrote in >> message >> news:C136B332-35D8-4B32-AA47-6FE720CE0FC1@microsoft.com... >> > Hi all, >> > After reaching page 19 in the newsgroup, I cant go on. Its the eyes you >> > see, >> > they cant see anymore :-) >> > >> > I have ReadOnly users in my db that I do not want to allow to see >> > certain >> > fields wherever they appear, be it in a table, form, query or report. >> > Its >> > to >> > do with medical info that should be kept private from them. >> > >> > Any ideas? >> > >> > Thanks in advance >> > >> > PaddyIrishMan >> >> >> Just grant the user
Show quoteHide quote "PaddyIrishMan" <PaddyIrish***@discussions.microsoft.com> wrote in message news:C136B332-35D8-4B32-AA47-6FE720CE0FC1@microsoft.com... > Hi all, > After reaching page 19 in the newsgroup, I cant go on. Its the eyes you > see, > they cant see anymore :-) > > I have ReadOnly users in my db that I do not want to allow to see certain > fields wherever they appear, be it in a table, form, query or report. Its > to > do with medical info that should be kept private from them. > > Any ideas? > > Thanks in advance > > PaddyIrishMan 
Other interesting topics
You do not have the necessary permissions to use the <name> object. Have your sy
Split Database not allowing more than one user Trusted location or publisher on removable drive I think this is a password problem? Create basic user for one database Permission Denied message how to join the workgroup security file system? Concurrent Users Editing form not possible because op exclusive opened Can't get access as an admin |
|||||||||||||||||||||||
