Lock people out

[Guest]

I am using Access 2003
I created an Access Db years ago that keeps track of laps used on machines.
This program is used by at least 15 different employees through out the
Plant. Every now and then one of the Queries appears not to work properly
and I have to recreate it again. I just found out that people are going into
the queries or tables to do what ever.
How can I lock people out of these two areas and still allow them to use the
forms and Reports that I created for them? Please let me know ASAP as I have
to get this db secure.

Aurora

 

[banem2]

I am using Access 2003
I created an Access Db years ago that keeps track of laps used on machines.
This program is used by at least 15 different employees through out the
Plant. Every now and then one of the Queries appears not to work properly
and I have to recreate it again. I just found out that people are going into
the queries or tables to do what ever.
How can I lock people out of these two areas and still allow them to use the
forms and Reports that I created for them? Please let me know ASAP as I have
to get this db secure.

Aurora

Hi Aurora,

Set Tools\Start Up options and hide Database Window. Create custom
menu and define which form will program run on start up. Still, users
can run db with SHIFT key and got access to design. If they do know
this trick, search for AllowBypassKey and how to turn it off (be aware
not to lock DB from your self).

Regards,
Branislav Mihaljev

 

[Guest]

I created an Access Db years ago that keeps track of laps used on machines.
This program is used by at least 15 different employees through out the
Plant. Every now and then one of the Queries appears not to work properly
and I have to recreate it again. I just found out that people are going into
the queries or tables to do what ever.
How can I lock people out of these two areas and still allow them to use the
forms and Reports that I created for them?

Sounds like all users have the SCHEMA privilege. Stating the obvious here
but why not revoke all privileges from the base tables, queries, etc for all
these users? You could then grant only the SELECT privilege, perhaps look at
WITH ACCESSOWNER OPTION for updates.

Jamie.

--