Limit Design View Access

[Guest]

I would like to limit design view access to all of my forms and queries is
there a way to do this through password protection?

 

[Scott McDaniel]

I would like to limit design view access to all of my forms and queries is
there a way to do this through password protection?

You can deploy your appliction in the .mde format (or .accde format for 2007), which will not allow anyone to view the
design of your Forms, Reports, or code modules. They would still be able to view the design of Tables and Queries,
however.

You can remove the database window (the screen where you see the Forms/Reports etc listed), so users wouldn't be able to
easily get to query design view. This is done in the Startup options (Tools - Startup). However, anyone linking to your
database from another Access app would be able to view your query and table design.

You can implement User Level Security and remove the ability of users to view your query and table design, but often
this requires a good bit of rewrite.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

Thanks for the information Scott, I will give the .mde a try.