Protecting a database and design

[Guest]

I have created a table in the design view and have entered all of the
information. Users will need to update the information as it changes but I
don't want them to be able to change the design. What do I need to do?

 

[BruceM]

While it doesn't offer much security, use a form to enter the data rather
than entering it into the table itself. You can set the startup options so
that the database window doesn't show. Knowledgeable users will be able to
override that setting, but there are ways to prevent that.
Beyond steps such as these you would need to implement security measures
such as user-level security. Access 2007 has a different security system, I
believe, so if you are using that version you should mention that.

 

[Larry Daugherty]

To protect your design, deliver the Front End as an MDE. Only you
should have the MDB for making changes.

HTH

 

[Guest]

How do I do this?
--
Shir

To protect your design, deliver the Front End as an MDE. Only you
should have the MDB for making changes.

HTH

 

[Larry Daugherty]

Look in Help for make MDE or just MDE to find the tools in your
version.

HTH