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