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, "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, "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@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