security

12 Dec 2006 7:29 PM

Pammy

We have a large latents database where our ID department enters information.
We created a a link called Latents Reports database where our Precincts, CID
and DA can view the tables or the form (it is on the sequel server and
records cannot be tampered with). Somehow, someone got into the design of
the form properties and tried to run a filter. This locked the form and it
would not open. (I have backup) Question, Is there a way to have the form
view only and prevent anyone from opening in design view? We have a large
number looking and running queries from this.

18 Dec 2006 3:52 AM

'69 Camaro

Hi, Pammy.

> Is there a way to have the form
> view only and prevent anyone from opening in design view?

The form doesn't have to be in Design View for someone to apply a filter to it.
It can be in Form View and a user can apply a filter or even change the sort
order. The only way to prevent someone from applying a filter to a form is to
implement User-Level Security and only allow Open/Run permissions to the form
for regular users (non-Admins).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Show quoteHide quote

"Pammy" <Pa***@discussions.microsoft.com> wrote in message
news:5F13EE13-E56F-477F-9EE6-B89F50CA2486@microsoft.com...
> We have a large latents database where our ID department enters information.
> We created a a link called Latents Reports database where our Precincts, CID
> and DA can view the tables or the form (it is on the sequel server and
> records cannot be tampered with). Somehow, someone got into the design of
> the form properties and tried to run a filter. This locked the form and it
> would not open. (I have backup) Question, Is there a way to have the form
> view only and prevent anyone from opening in design view? We have a large
> number looking and running queries from this.