Re: Protecting DB

"Luis" wrote in message:
news:23BD493F-B1E5-42C4-AA77-5BE3603E8254@xxxxxxxxxxxxxxxx

> Hello.
> I'm trying to protect an Access Db 2003.
> I've already hide the db objects, but it is still possible to link or import
> the objects to another Db.
> Is it possible to prevent one user to import or link the db objects to
> another db?

Hi Luis,

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.

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.

In addition you should create custom menu bars and toolbars to limit
what the users can do. Check under Tools | Startup and set limited
startup properties for your users. Hide the Database Window, select
a startup form, uncheck Allow Special Keys, etc. You may also want
to disable the Shift key bypass for those users who are wedgie resilient.
Details on that technique can be found here:

http://www.mvps.org/access/modules/mdl0011.htm

http://www.mvps.org/access/general/gen0040.htm

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 Links:
http://www.ltcomputerdesigns.com/JCReferences.html#Security

Good luck,
--
Jeff Conrad
Access Junkie
Bend, Oregon


.

Relevant Pages

  • Re: Opening codes
    ... Doug Steele, Microsoft Access MVP ... 'This function will disable the shift at startup causing the Autoexec ... Dim db As Database ...
    (microsoft.public.access.modulesdaovba)
  • Re: Opening codes
    ... more secure syntax shown in http://www.mvps.org/access/general/gen0040.htm ... 'This function will disable the shift at startup causing the Autoexec ... Dim db As Database ...
    (microsoft.public.access.modulesdaovba)
  • RE: Retrieve no. of forms, tables, etc. from Access DBs
    ... There are, I believe, two ways to make screens like this ... Startup code that is... ... Any of the 25000 database in the list may contain code that runs ... If so, when I run the below example in Excel, code execution ...
    (microsoft.public.access.modulesdaovba)
  • Re: Table creation
    ... >> Isn't there a way to make the database window unavailable to certain ... > Create a startup form that is opened on ... > Use the features in Tools, ... > If you need to bypass these startup features, you can hold the shift key ...
    (microsoft.public.access.security)
  • Re: TADOQuery fields list box.
    ... I need to do it with code so that when the program runs it does it at startup. ... The restructuring of the database is done after initial startup. ... What I have done is added a new TADOQuery element to the program called System2, this one holds all the fields including the two new fields. ...
    (comp.lang.pascal.delphi.databases)