Very delicate question about importing objects

R

Rick B

I think one way would be to take away their access to the objects mentioned.

You can take away all access and only allow the user to work with your
forms. The forms could be based on a saved query set to run with owner's
permission.

Rick B
 
A

ANSWER

Hi
Is there any way I could disable user to create a new database and import
all of my tables and queries into his database.
I make .mde, disable shift+Enter, make logon users module but still my
tables and queries are free to take.
If you know couple solutions please let me know so I can decide.

Thanks
 
A

Arvin Meyer

You must implement User-Level security. Read the Security FAQ and make sure
you follow it exactly:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

To achieve what you want you deny all access to the tables for everyone
except those who do so WITHOWNERACCESS OPTION queries. Now, no one has any
permission to view any data except through the forms and reports based upon
the queries you decide. Outsiders who have may have access to the server but
not to the local front-ends, are locked out.

It should be pointed out that there are possible cracks to Access security.
If it is really important, like HIPPA laws or maintenance of private
information, use an Access front-end to a SQL-Server back-end. Then the
server engine itself will keep out everyone.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top