Editing Form Layout/Design without Permission

[JT Kent]

Hello All,
I wish to know how i can prevent users from editing the layout/design of my forms, reports or queries without authorisation.

I realise that i can prevent users from editing my vba code by using a password but is there a way i can prevent them from adjusting the other objects in my database application?

Thank you.

 

[Dairy Farmer]

make the db a mde, accde or accdr

 

[Galaxiom]

An accdr can be edited by simply changing the extension back to accdb.

However if you use a properly distributed front end they will only be damaging their own copy (unless they get hold of the master distribution copy).

The mde or accde is the way to go.

 

[Dairy Farmer]

An accdr can be edited by simply changing the extension back to accdb.

I include accdr as an option as this is a version that could get distrubuted with Runtimes to users who don't have Access installed. As far as I'm aware you can't edit with Runtimes, only run the aplication.

I know that Runtimes can read the other formats, its just the way I package my apps. The user could change the extension, but consider this:

How may ordinary users would know this to do this?
Most users have "Hide extensions for known file types" turned off, so the extension isn't immediatly visible.
In most environments it is more cost effective to have Runtimes (free) installed on users computers than have to license many copies of Access (which generally comes as an add on to Office).
Even if the user is to has Access installed, I still install Runtimes as one of the standard apps on any computer I work on (along with apps like VisioViewer, Foxit, FastStone, CutePDF,...)

 

[JT Kent]

Hi Everyone,
i followed your suggestion (accde format) and it worked except that i can still edit Queries. Why is that so and what can i do to prevent users from editing the Queries?

Thank you.