stoppng changes to design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a room booking .mdb so people can type their name in the bookings form and are trusted to not overwrite others, but I want to stop access to all other areas (design, query toolbars etc etc)

We are on a win2000 network and dont want to setup special users and groups. There are 100's of potential user

Can I set this for everyone and anyone apart from an single administrator account?
 
you could acomplish basic removal of access to design and
any Access object by setting start up properties.

Tools>Start Up

you could probably uncheck everything except special
access keys.

you can still get access to the database window by using
the by pass key but the basic user wouldnt know about this.

i code the start up options on all of my databases and
could post code if you want to take that route.

HTH

Brian
-----Original Message-----
We have a room booking .mdb so people can type their name
Click to expand...
in the bookings form and are trusted to not overwrite
others, but I want to stop access to all other areas
(design, query toolbars etc etc).
We are on a win2000 network and dont want to setup
Click to expand...
special users and groups. There are 100's of potential
users
 
just thought of another option.

set up user level security with only 2 user accounts

One general account with read only access, and the default
admin account with full access.

allow all of your users to use the general account

you can set up a specific workgroup file and keep this
seperate from everything else.

Brian
-----Original Message-----
We have a room booking .mdb so people can type their name
Click to expand...
in the bookings form and are trusted to not overwrite
others, but I want to stop access to all other areas
(design, query toolbars etc etc).
We are on a win2000 network and dont want to setup
Click to expand...
special users and groups. There are 100's of potential
users
 
Back
Top