Security nightmare

[George]

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?
Issue 2: How can I reset the security in order to create an unsecured
database?

Thanks a lot in advance

George

 

[Rick Brandt]

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.

 

[George]

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).
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?

Thanks again for your help

George

Ο χÏήστης "Rick Brandt" έγγÏαψε:

 

[Rick Brandt]

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.

 

[George]

Dear friend,

Thanks a million ))))

George

Ο χÏήστης "Rick Brandt" έγγÏαψε: