RE: Security on a Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

The security topic is not small, I suggest you read the help file, but just
to point you where to start:

a. Use the "User-Level Security Wizard" located in Tools/Security menu.

and for
b. If you your client has Access, simply send the database, security file,
and a shortcut (the security topics in Access help have more detail) in a CD
or via e-mail in a zipped file, if the client does not have access and you
want to distribute more applications in the future, I will recommend you buy
the Developer extensions for Microsoft office if you are using Access 2003,
they have a packaging wizard that helps distribute applications with their
own setup,

--
jl5000
<a href="http://www.joshdev.com";></a>


"Angeline" wrote:

> Hi,
> I work independently but I am currently buiding a database to capture staff
> exit interviews for a Corporate Client. I am a bit of a novice in ACCESS but
> have been able to build queries and forms to meet all the needs of the
> program.
>
> Whilst I built it for myself, to be able to calculate patterns and trends of
> dissatisfaction among staff - they (The Client) have requested to view all
> the interviews which can be viewed from a form which has about 10 page tabs.
>
> Rather than send them the main table which the form points to, I would
> prefer to send them the database but only allow them to view one form within
> it.
>
> Can someone help me with :
> a: How I program the database to secure everything else from being viewed
> excpet this form. The form already has open on activate database built into
> it but I want to be able to prevent them from going anywhere else.
>
> b: How can I package up the database so that I can send it across to them
> and of course they would require to have ACCESS on their site.
>
> Hope someone can help. Many Thanks!
> Angeline
.

Relevant Pages