Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created some reports in the my company share drive so that some of the
managers can access to view or print. However, someone changed the format of
the report.

Is there a way to secure the report so that I am the only one can change the
data or format. Thanks.
 
What do you mean you created some reports on a shared drive? Did you do
this in an Access database? Do you want other users to be able to open the
database at all? If so, should they be able to run those reports, but not
modify the design?

Assuming that is what you want, you would need to secure your database using
user-level security and then grant appropriate permissions to the report so
they could view it, but not change the deisgn.

You might also try making an MDE file and placing that in the shared
location. The original MDB file could be kept in a location that only you
can access. The users would be able to use the MDE file, but would not be
able to modify the design of your reports. They would be able to create new
reports (I think).
 
Hello "Bltony".

Bltony said:
I created some reports in the my company share drive so that some
of the managers can access to view or print. However, someone
changed the format of the report.

Is there a way to secure the report so that I am the only one can
change the data or format. Thanks.
Click to expand...

You will have to secure your database, this includes:
Create a new mdw file
Create a new user for you.
Add that user to the admins group
Remove the admin from the admins group
Give the admin a password
Log on the Access as your new user (give him a password too)
Create a new database
Import everything to the new database
Create users and groups, assign users to groups,
grant permissions to the groups.
Make sure that the "Users" group has no permissions at all.
Take the old database from the network.

See: http://support.microsoft.com/support/access/content/secfaq.asp
 
I have the same question. I am going to post my Access database on a shared
drive for others to be able to view and print reports and forms.
How can I hide the queries and tables and macros from my user's view? Also I
dont want them to be able to change report design. How can I "secure my
database using user-level security and then grant appropriate permissions to
the report"
 
Back
Top