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@yahoogroups.com] On Behalf Of S and M
Sent: Friday, June 24, 2011 3:40 PM
To: MS_Access_Professionals@yahoogroups.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, "S and M"
<redneck_coonass_cpl@...> wrote:
>
> Bill,
>
> It's ok,...more is better,...lol.
>
> Thanks, Steven
>
> --- In MS_Access_Professionals@yahoogroups.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, "S and M"
<redneck_coonass_cpl@> wrote:
> > >
> > > Again,...thank you John!!!!
> > >
> > > --- In MS_Access_Professionals@yahoogroups.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@yahoogroups.com] On Behalf Of S and M
> > > > Sent: Wednesday, June 22, 2011 5:11 PM
> > > > To: MS_Access_Professionals@yahoogroups.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
Tidak ada komentar:
Posting Komentar