Design View

[Denver]

is there any other way of hiding Design View without converitng if thru MDE
for Forms or Reports
to prevent user from changing design of my database?
like prompt a password.. would be great while i am on my way of enhancing my
database.. is this possible? do i need any codes? what code be look like?

thanks for any help.

denver

 

[Jeanette Cunningham]

Hi Denver,
the usual way to do this is to split the database into a front end and a
backend.
You can use the database splitter in Tools | Database Utilities | Database
Splitter

Next step is to make a mde from the front end.
Your users use the mde - which stops them from making changes to forms and
reports.
You keep a copy of the mdb used to make the mde.
You make a copy of the mdb used to make the mde and use it as your working
database for the changes you are making.
When you have finished making changes, make the new working mdb into a mde
and put on user's machines.

Repeat the process as needed.

You can use the Start up settings to keep users out of the database window
(assuming A2003 or lower)
Tools | Startup
This can hide the database window for you.
To show the database window, open the database while you hold down the Shift
key.
To prevent users doing the same, there is a free utility called ShiftKey
from Access MVP Albert Kallal.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia