Phil
You might also read my article at http://thatlldoit.com/howtosarticles.aspx#mdw_fix for more info.
Bill
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Phil-
>
> When you "secured" your database, you should have done:
>
> 1) Create a new .mdw
> 2) Add a password to Admin in the new .mdw
> 3) Create a new user in the Admins group and assign a password
> 4) Copy all your objects to a new database while signed on as the new user â€" that makes sure that Admin does NOT own the database.
> 5) Remove all permissions to all objects for the USERS group in the new database.
> 6) Create new users and groups and assign permission as needed.
>
> I suspect you skipped step 5.
>
> 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)
>
> -----------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
> Sent: Wednesday, March 28, 2012 12:29 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Moving a secured 2003 db to a 2010 environment
>
>
> Hi Bill
>
> I did but if the database file is copied and put on a PC over which I have no control and has the standard system .mdw then it would appear that it will open quite happily with no security. Is this the case?
>
> cheers
>
> Phil
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, 27 March 2012, 20:10
> Subject: [MS_AccessPros] Re: Moving a secured 2003 db to a 2010 environment
>
>
> Your Name?
>
> It sounds like you did not give Admin a password and remove all his permissions. You must do that so Admin cannot open the database.
>
> Bill Mosca, founder
>
> --- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@> wrote:
> >
> > I have a db created in 2003 and I want to move it to 2010 but at the same time introduce usernames and passwords.
> >
> > I have set up the usernames and passwords on a 2003 PC and am now trying to move the db and the associated .mdw file (where all the usernames and passwords are defined) to a pc running 2010.
> >
> > This has worked fine and I have created desktop shortcuts to use the appropriate .mdw file.
> >
> > However, if I simply run access 2010 and then open the db, it ignores the mdw file I want it to use and uses the default system.mdw - this has the effect of opening the database with no security!
> >
> > How can I make sure that the database will only open in conjunction with the correct associated mdw file?
> >
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar