Stop userrs importing objects

  • Thread starter Thread starter ANSWER
  • Start date Start date
A

ANSWER

Hi,

How can I stop user to import into his database my objects: tables and
queries.
Please help me to solve this.

Thank you.
 
Hi,

How can I stop user to import into his database my objects: tables and
queries.
Please help me to solve this.
Click to expand...

I already answered your question in the general Access forum newsgroup
two hours after you posted the message on Feb 25.
Did you not see my reply?

Here it is again:

The only way to do this is to implement full blown Access User Level
Security (ULS). You would then deny all permissions on the tables
themselves and create RWOP queries for the users to access the table
information. Assigning appropriate permissions to various database objects
would also be needed. The users could still possibly import the queries
into another container, but they would essentially be worthless since
they would not be able to access the data in the BE file. You could
also distribute MDE files (a good idea anyway) which would prevent
tampering with your code and prevent importing of forms, macros,
reports, and modules.

If you have never used ULS before, be prepared for a lot of work ahead
of you. ULS is not a trivial undertaking at all so I would recommend
ALL of the following reading material before beginning. Also, practice
on dummy databases until you are really comfortable with it.

Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm

The Security Whitepaper is also worth reading:
http://support.microsoft.com/?id=148555

Keith Wilby's Instructions (See step-by-step link)
http://www.keithwilby.com/

Other Good Information:
http://www.access-experts.com/default.aspx?selection=TutorialSecurity&sm=18

Other Microsoft KB articles of interest:

Description of how to help protect a Access 2000 database:
http://support.microsoft.com/?id=254372

Description of the role of workgroup information files in Access security:
ACC97: http://support.microsoft.com/?id=303941
ACC2000: http://support.microsoft.com/?id=305541
ACC2002/2003: http://support.microsoft.com/?id=305542

Exploring Microsoft Access Security:
http://msdn.microsoft.com/library/d...s/dnacc2k2/html/odc_AcSecurity.asp?frame=true

Good luck,
 
Back
Top