> George wrote:
> > Dear gurus - need your help again,
> >
> > I helped a friend to secure his access database in his office server
> > - using the User-Level security wizard. Now, he asked me to create
> > some more reports for his database.
> >
> > Issue 1: When i copied the database on my PC does not open. Why?
>
> Because you secured it.  You need to include the MDW file so that you can use
> that for the session and log in with an appropriate account.  You would either
> need to temporarily "join" that workgroup file or else start Access with a
> command line argument that specifies it.
>
> "path to msaccess.exe" /wrkgrp "path to mdw" "path to mdb"
>
> > Issue 2: How can I reset the security in order to create an unsecured
> > database?
>
> You would still need the mdw file to do that so there is no point.  Once you
> have the mdw file then you will not need to remove security.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
>
>
>

> George wrote:
> > Thank a lot Rick,
> >
> > I have manage to open the database.  Now the problem is that I will
> > create few reports and I want to be able to copy them to my friend's
> > database in a few days (in the meantime he will record many things in
> > the database).
>
> This is whay most developers "split" their apps.  One file for data (tables
> only) and one file for everthing else that contains links to the data file.
> Then interface design changesa are simply a matter of replacing the "front end"
> file with a different one without affecting the data.
>
> > Since this is a secured database I believe that I will
> > not be able to copy reports to his secured database.  Is there any
> > way to do that?  Either to copy or import those reports to his
> > database?  Do I need to unsecure my database and how?
>
> As long as you open the file with an account having adequate permissions there
> is no reason you cannot import new reports from other files.  You will have to
> set permissions on them afterwards but otherwise security does not affect this
> area.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
>
>
>