>Hello,
>
>I am simply trying to test out Access user-level security.  I am following
>instructions
>in the SAMS Acess 2000 book for using the security wizard on an existing
>test database.  But every time I get to the end of the wizard, I get the
>following error message:  "An unexpected error occurred while changing the
>owner of the
>database ...".  I have tried changing the Windows ownership of the mdb to
>match my Domain/Administrator login, but that didn't help. 
>
>Also, I never saved off the original mdw file.  Is there a way to retrieve a
>fresh copy
>of that file from the Access CD or somewhere ?
>
>P.S.  From the looks of other postings, this Access security thing is not
>exactly
>        straightforward, is it ?!!
>
>Thanks,
>Tom
>
>

"Jack MacDonald" <jackMACmacdon***@telus.net> wrote in message
news:t32u51tmef9mk81ahs5hmqvj8cree32s1v@4ax.com...
> Well, there are lots of pitfalls to security unless you do it right. I
> would recommend that you invoke security manually, rather than using
> the wizard. You can find my documentation at
> www.geocities.com/jacksonmacd
>
> There are links to several other sites with similar manual
> instructions.
>
> You cannot change the ownership of a database. You can only create a
> new database under the correct ownership, import the objects, and
> change their ownership.
>
> I believe that if you run Access without a MDW file, it will create a
> new one for you.
>
>
> On Thu, 14 Apr 2005 10:06:05 -0700, "Tom Glasser"
> <TomGlas***@discussions.microsoft.com> wrote:
>
>>Hello,
>>
>>I am simply trying to test out Access user-level security.  I am following
>>instructions
>>in the SAMS Acess 2000 book for using the security wizard on an existing
>>test database.  But every time I get to the end of the wizard, I get the
>>following error message:  "An unexpected error occurred while changing the
>>owner of the
>>database ...".  I have tried changing the Windows ownership of the mdb to
>>match my Domain/Administrator login, but that didn't help.
>>
>>Also, I never saved off the original mdw file.  Is there a way to retrieve
>>a
>>fresh copy
>>of that file from the Access CD or somewhere ?
>>
>>P.S.  From the looks of other postings, this Access security thing is not
>>exactly
>>        straightforward, is it ?!!
>>
>>Thanks,
>>Tom
>>
>>
>
>
> **********************
> jackmacMACdon***@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security

"RipperT @comcast.net>" wrote:

> > Well, there are lots of pitfalls to security unless you do it right. I
> > would recommend that you invoke security manually, rather than using
> > the wizard.
>
> Jack speaks the truth. I recommend securing and splitting manually, not
> using the wizards. Go here http://support.microsoft.com/?kbid=165009 and
> download and read the MS Access Security FAQ. It is loaded with info. Study
> it. Learn it. Live it. Love it. (Well, maybe not that last one). Also go
> here http://www.ltcomputerdesigns.com/Security.htm and compare the two.
> Google MS Access security and find other docs on how to secure your DB, then
> compare them all. One will probably clear up whatever you might not
> understand in another. This is how I did it and believe me, it's worth the
> trouble. I spent weeks studying multiple resources, then praticed on
> 'practice' DB's til I got it right (always practice on backups!). I even
> locked myself out a couple of times, but I learned how it works.
>
> > I believe that if you run Access without a MDW file, it will create a
> > new one for you.
>
> If you delete the system.mdw file, Access will cough up a brand new one upon
> the next running of Access.
>
> Good luck,
>
> Rip
>
> --
> Ripper T Smith
> rippertsmith<nospam>@comcast.net
> "Jack MacDonald" <jackMACmacdon***@telus.net> wrote in message
> news:t32u51tmef9mk81ahs5hmqvj8cree32s1v@4ax.com...
> > Well, there are lots of pitfalls to security unless you do it right. I
> > would recommend that you invoke security manually, rather than using
> > the wizard. You can find my documentation at
> > www.geocities.com/jacksonmacd
> >
> > There are links to several other sites with similar manual
> > instructions.
> >
> > You cannot change the ownership of a database. You can only create a
> > new database under the correct ownership, import the objects, and
> > change their ownership.
> >
> > I believe that if you run Access without a MDW file, it will create a
> > new one for you.
> >
> >
> > On Thu, 14 Apr 2005 10:06:05 -0700, "Tom Glasser"
> > <TomGlas***@discussions.microsoft.com> wrote:
> >
> >>Hello,
> >>
> >>I am simply trying to test out Access user-level security.  I am following
> >>instructions
> >>in the SAMS Acess 2000 book for using the security wizard on an existing
> >>test database.  But every time I get to the end of the wizard, I get the
> >>following error message:  "An unexpected error occurred while changing the
> >>owner of the
> >>database ...".  I have tried changing the Windows ownership of the mdb to
> >>match my Domain/Administrator login, but that didn't help.
> >>
> >>Also, I never saved off the original mdw file.  Is there a way to retrieve
> >>a
> >>fresh copy
> >>of that file from the Access CD or somewhere ?
> >>
> >>P.S.  From the looks of other postings, this Access security thing is not
> >>exactly
> >>        straightforward, is it ?!!
> >>
> >>Thanks,
> >>Tom
> >>
> >>
> >
> >
> > **********************
> > jackmacMACdon***@telusTELUS.net
> > remove uppercase letters for true email
> > http://www.geocities.com/jacksonmacd/ for info on MS Access security
>
>
>

"Jack MacDonald" wrote:

> Well, there are lots of pitfalls to security unless you do it right. I
> would recommend that you invoke security manually, rather than using
> the wizard. You can find my documentation at
> www.geocities.com/jacksonmacd
>
> There are links to several other sites with similar manual
> instructions.
>
> You cannot change the ownership of a database. You can only create a
> new database under the correct ownership, import the objects, and
> change their ownership.
>
> I believe that if you run Access without a MDW file, it will create a
> new one for you.
>
>
> On Thu, 14 Apr 2005 10:06:05 -0700, "Tom Glasser"
> <TomGlas***@discussions.microsoft.com> wrote:
>
> >Hello,
> >
> >I am simply trying to test out Access user-level security.  I am following
> >instructions
> >in the SAMS Acess 2000 book for using the security wizard on an existing
> >test database.  But every time I get to the end of the wizard, I get the
> >following error message:  "An unexpected error occurred while changing the
> >owner of the
> >database ...".  I have tried changing the Windows ownership of the mdb to
> >match my Domain/Administrator login, but that didn't help. 
> >
> >Also, I never saved off the original mdw file.  Is there a way to retrieve a
> >fresh copy
> >of that file from the Access CD or somewhere ?
> >
> >P.S.  From the looks of other postings, this Access security thing is not
> >exactly
> >        straightforward, is it ?!!
> >
> >Thanks,
> >Tom
> >
> >
>
>
> **********************
> jackmacMACdon***@telusTELUS.net
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>