Jumat, 08 Juli 2011

Re: [MS_AccessPros] 2002 User level Security - Now 2003

 

I see that. So I am good to go right,...I can start creating "groups",...adding "user ID's" to the groups and adjust the permissions for the individual groups?

Should I be installing the Security Manager add on or do I need it?

Thanks,

Steven

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Steven
>
> When you secure a db using the wizard it moves Admin out of the Admins group and takes away all his rights. This is so someone cannot use the default System.MDW to open your database.
>
> Therefore, when you log in Admin you have no rights and probably can't even open the darn thing. That's the way it should be.
>
> You must log in as yourself. You should be a user in the Admins group. Note the difference. Admin in the Users vs Steven in the Admins group
>
> Capeesh?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, "S and M" <redneck_coonass_cpl@> wrote:
> >
> > John and All,
> >
> > Ok, well that makes some since I guess. Here is where I am,...I ran the security Wizard and created a new file and a shortcut.
> >
> > I then tried to log back in as the Admin user but it would not allow me to.
> >
> > When in the wizard, it create a new user named Steven and I CAN log in with it. However, all the instructions I have tell me to log in as Admin,...so I am a bit confused (or scared,...lol)
> >
> > I ran the the User and Group Accounts in the security menu and Steven is in the Admins and Users group,...which I think is where I need to be.
> >
> > The Admin user is only in the Users group,...which I find strange.
> >
> > What I want to wind up with is for the user Steven, me, to have full access and for there to be two other groups with very limited access as I define them. However, before I start changing too much I want to make sure I am in the right place.
> >
> > Should I now be installing the Security Manager add on now?
> >
> > Thanks, Steven
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Steven-
> > >
> > > If you're using the Security Wizard, I don't think you need to create and join a
> > > new .mdw first. The Wizard will create on for you.
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of S and M
> > > Sent: Wednesday, July 06, 2011 8:52 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] 2002 User level Security - Now 2003
> > >
> > > Ok, I think I am back to the beginning again. I deleted the MDW file I created
> > > as well as the secured database I could not access and restored the backup.
> > >
> > > I am following the User level security instruction,..I think Bill wrote this.
> > >
> > > I created a new MDW file and joined it. I then started the Security Wizard
> > > ,...the instructions say to modify the current one,...but I do not have that
> > > option.
> > >
> > > I think this is where I went wrong the last time.
> > >
> > > What have I missed that I do not have the option to modify the existing one?
> > >
> > > Thanks, Steven
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@>
> > > wrote:
> > > >
> > > > Steven
> > > >
> > > >
> > > >
> > > > Let me know if you can't get in to your DB.
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > > Bill
> > > >
> > > >
> > > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of S and M
> > > > Sent: Friday, June 24, 2011 1:39 PM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: Re: [MS_AccessPros] 2002 User level Security - Now 2003
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Bill,
> > > >
> > > > I did set up the shortcut. However, it would not let me modify an existing
> > > file
> > > > so I created a new one,...probably a mistake.
> > > >
> > > > After that I think I reset the admin password.
> > > >
> > > > I THINK what happened is that it logged me in as user "Steven" instead of
> > > > "admin",....now I am locked out.
> > > >
> > > > Unfortunately, I got pulled away right after that and have not been able to
> > > get
> > > > back too it.
> > > >
> > > > Hope every one has a great weekend!!!
> > > >
> > > > Thanks, Steven
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
> > > > wrote:
> > > > >
> > > > > Steven
> > > > >
> > > > > Did you set your password? If you didn't just login without one.
> > > > >
> > > > > And you set up a shortcut like I described in my article, right? If you did
> > > > not Access is trying to log you in using the default System.mdw which of
> > > course
> > > > won't work.
> > > > >
> > > > > Bill
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "S and M"
> > > > <redneck_coonass_cpl@> wrote:
> > > > > >
> > > > > > John,
> > > > > >
> > > > > > I was able to install a complete 2003 package so the wizard now works.
> > > > > >
> > > > > > I am missing something somewhere. I think maybe Bill has pointed it
> > > out,...I
> > > > may not be logging in as the user admin,...but I do not know why as it was not
> > > > asking me for a log in,....now I am locked out.
> > > > > >
> > > > > > Steven
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas" <john@>
> > > > wrote:
> > > > > > >
> > > > > > > Steven-
> > > > > > >
> > > > > > > I thought you said you couldn't get the Wizard to work? My steps below
> > > are
> > > > how
> > > > > > > to do it "by hand." Did you follow steps 1-6?
> > > > > > >
> > > > > > > John Viescas, author
> > > > > > > Microsoft Office Access 2010 Inside Out
> > > > > > > Microsoft Office Access 2007 Inside Out
> > > > > > > Building Microsoft Access Applications
> > > > > > > Microsoft Office Access 2003 Inside Out
> > > > > > > SQL Queries for Mere Mortals
> > > > > > > http://www.viescas.com/
> > > > > > > (Paris, France)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > [mailto:MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of S and M
> > > > > > > Sent: Friday, June 24, 2011 3:40 PM
> > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > Subject: [MS_AccessPros] 2002 User level Security - Now 2003
> > > > > > >
> > > > > > > Ok, I managed to get upgrade to 2003 so I started over.
> > > > > > >
> > > > > > > I created a new MDW file and all seemed to go well,...I joined it.
> > > > > > >
> > > > > > > I then went to open the wizard and it would not allow me to select
> > > "modify
> > > > the
> > > > > > > current one,..." It will only allow me to create a new one,...which I
> > > did
> > > > NOT
> > > > > > > DO.
> > > > > > >
> > > > > > > What am I doing wrong? Should I be using the security manager add on
> > > > instead of
> > > > > > > the wizard for this step. I have the add on but have not installed it
> > > > because I
> > > > > > > was upgrading.
> > > > > > >
> > > > > > > Thanks, Steven
> > > > > > >
> > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "S and M"
> > > > > > > <redneck_coonass_cpl@> wrote:
> > > > > > > >
> > > > > > > > Bill,
> > > > > > > >
> > > > > > > > It's ok,...more is better,...lol.
> > > > > > > >
> > > > > > > > Thanks, Steven
> > > > > > > >
> > > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
> > > > wrote:
> > > > > > > > >
> > > > > > > > > John
> > > > > > > > >
> > > > > > > > > RATS! I started a response to Steven and got called away. I posted
> > > > before I
> > > > > > > checked back on the thread.
> > > > > > > > >
> > > > > > > > > Bill
> > > > > > > > >
> > > > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "S and M"
> > > > > > > <redneck_coonass_cpl@> wrote:
> > > > > > > > > >
> > > > > > > > > > Again,...thank you John!!!!
> > > > > > > > > >
> > > > > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas" <john@>
> > > > > > > wrote:
> > > > > > > > > > >
> > > > > > > > > > > Steven-
> > > > > > > > > > >
> > > > > > > > > > > 1) Create a new Workgroup file.
> > > > > > > > > > >
> > > > > > > > > > > 2) Point to that new Workgroup file and start Access using any
> > > > database.
> > > > > > > > > > >
> > > > > > > > > > > 3) Define a new user that is a member of the Admins group and
> > > > define a
> > > > > > > password.
> > > > > > > > > > >
> > > > > > > > > > > 4) Assign a password to the Admin user to force you to login.
> > > > > > > > > > >
> > > > > > > > > > > 5) Restart Access and login with the new UserID that has Admin
> > > > > > > privileges.
> > > > > > > > > > >
> > > > > > > > > > > 6) Remove the Admin user from the Admins group.
> > > > > > > > > > >
> > > > > > > > > > > 7) Create a new database and import all the objects from the
> > > > database
> > > > > > > that you
> > > > > > > > > > > want to secure.
> > > > > > > > > > >
> > > > > > > > > > > The new database and all the objects are now "owned" by your new
> > > > UserID.
> > > > > > > > > > >
> > > > > > > > > > > 8) Remove all privileges to the Users group for all objects.
> > > This
> > > > is a
> > > > > > > step
> > > > > > > > > > > done automatically by the Wizard because it can be a bit
> > > tedious.
> > > > > > > > > > >
> > > > > > > > > > > 9) Remove all authority to the Users group to create any new
> > > > object -
> > > > > > > tables,
> > > > > > > > > > > queries, forms, reports, macros, modules.
> > > > > > > > > > >
> > > > > > > > > > > 10) Create a new Group and Users assigned to that group.
> > > > > > > > > > >
> > > > > > > > > > > 11) Assign the permissions you want for objects to the new
> > > Group.
> > > > > > > > > > >
> > > > > > > > > > > John Viescas, author
> > > > > > > > > > > Microsoft Office Access 2010 Inside Out
> > > > > > > > > > > Microsoft Office Access 2007 Inside Out
> > > > > > > > > > > Building Microsoft Access Applications
> > > > > > > > > > > Microsoft Office Access 2003 Inside Out
> > > > > > > > > > > SQL Queries for Mere Mortals
> > > > > > > > > > > http://www.viescas.com/
> > > > > > > > > > > (Paris, France)
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > From: MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > > > > > [mailto:MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of S and M
> > > > > > > > > > > Sent: Wednesday, June 22, 2011 5:11 PM
> > > > > > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > > > > > Subject: [MS_AccessPros] 2002 User level Security
> > > > > > > > > > >
> > > > > > > > > > > Hello again,
> > > > > > > > > > >
> > > > > > > > > > > When it rains it pours. I am setting up user level security on
> > > the
> > > > new
> > > > > > > database
> > > > > > > > > > > on the OLD computer.
> > > > > > > > > > >
> > > > > > > > > > > I am following Bills instructions he wrote some time back. All
> > > was
> > > > well
> > > > > > > until I
> > > > > > > > > > > went to run the security wizard. Seems that the wizard feature
> > > was
> > > > not
> > > > > > > > > > > installed when they first installed office.
> > > > > > > > > > >
> > > > > > > > > > > It will not install it without the original cd's for Office
> > > which
> > > > no
> > > > > > > longer
> > > > > > > > > > > exist.
> > > > > > > > > > >
> > > > > > > > > > > So, is there a way to set it up without the wizard?
> > > > > > > > > > >
> > > > > > > > > > > The whole idea here is to restrict users (other than admins)
> > > from
> > > > > > > accessing the
> > > > > > > > > > > information is certain tables and from generally "looking"
> > > around.
> > > > I do
> > > > > > > not
> > > > > > > > > > > want to have to "fix" anything because someone accidentally
> > > > deleted a
> > > > > > > "." or
> > > > > > > > > > > something....lol.
> > > > > > > > > > >
> > > > > > > > > > > Thanks for all the help,
> > > > > > > > > > >
> > > > > > > > > > > Steven
> > > > > > > > > > >
> > > > > > > > > > > So close yet so far away!!!
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > ------------------------------------
> > > > > > > > > > >
> > > > > > > > > > > Yahoo! Groups Links
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ------------------------------------
> > > > > > >
> > > > > > > Yahoo! Groups Links
> > > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
>

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar