Locking Access object creation to users

[Chuck Sigmund]

We want to make Access 2007 available to our users so they can read the
tables and databases, but we do not want them to be able to create any new
objects, including databases, tables or queries. Is there a way to do this
that anyone has come up with?

Thanks for the assistance,
Chuck Sigmund

 

[Larry Daugherty]

Assuming that you have split your application ... Compile your
application. Make an MDE or ACCDE. distribute a copy to your users.
They should each have a copy on their desktop. From the ***DE they
can edit and update data as you have provided the tools but they
cannot alter the design.

HTH

 

[John W. Vinson]

We want to make Access 2007 available to our users so they can read the
tables and databases, but we do not want them to be able to create any new
objects, including databases, tables or queries. Is there a way to do this
that anyone has come up with?

Thanks for the assistance,
Chuck Sigmund

In addition to the ACCDE suggestion, if you have admin control over their
software, you can ensure that they have only the Access Runtime installed, not
the full version of Access.

 

[Albert D. Kallal]

We want to make Access 2007 available to our users so they can read the
tables and databases, but we do not want them to be able to create any new
objects, including databases, tables or queries. Is there a way to do
this
that anyone has come up with?

Thanks for the assistance,
Chuck Sigmund

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. (or for 2007, office
button->access options).

Using those options allows you to complete hide the ms-access interface
(tool bars, database window etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

It is generally assumed that you split your application, so distributing a
accDE is a recommended approach.