Re: Security setup, completely lost
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Fri, 10 Aug 2007 20:09:52 -0400
"Freehal04" <Freehal04@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AFBB9875-1CAD-484A-A5A6-648801336FF2@xxxxxxxxxxxxxxxx
Alright, this one is really got me stumped. (Access 2003)
Did the set up step by step.
First I'm not sure what that means, but I got some advice to make sure thatI
start out with only one mdw file, the default System.mdw. Did that.
Just because it's named that, doesn't mean it's a pristine workgroup file. I would delete all mdw files. Start up Access, and it'll create a new clean system.mdw for you.
Also
was adviced to make sure my db wasn't previously 'secured' in any way. To
this I created a new db after all my failed attempts of .mdw files were
deleted and I thought I was starting out fresh.
Yes create a new mdb and import everything from you old mdb.
Well, I create a new user in step 7 of the Step-by-Step process and when I
get to step 12, it won't recognize my user I created in step 7.
I'm going to assume you didn't skip steps 8 through 11 <g> Probably the user you created in step 7 does not have a password. You might be thinking that the PID you used to set up the new user is a password. It isn't. In your case the new user's password is initially blank/null. Once you login as this user, you then change the null password to something else.
So either way I've totally messed something up. I don't know why this is so
hard, but it is. If you have any advice please help.
Security is hard to get right. I don't know anyone who got it 'right' the first time through.
I gather that you are following the steps in the security FAQ. It is important that you follow each and every step (don't pass over anything).
If you'd like to try again, go back to your unsecured backup (you have one right?), delete or rename all mdw files you have on your computer, and start over. The security wizard in 2003 does a better job than earlier versions. You might like to the try the detailed steps I've outlined at www.jmwild.com/security02.htm
--
Joan Wild
Microsoft Access MVP
.
- Prev by Date: Re: Protecting tables/queries from changes not in forms
- Next by Date: Re: Protecting an Access Database
- Previous by thread: Re: Protecting tables/queries from changes not in forms
- Next by thread: Re: Security setup, completely lost
- Index(es):
Relevant Pages
|
