How can i disable right click on report ?

[moonrb]

hi

How can i disable right click on report that a user can not change the design of the report.
i am using access 2002

Thanks.

[Rabbit]

Give the user a compiled version of the database. But remember to keep an uncompiled version for yourself so you can make changes.

[zmbd]

This will stop other popups too so be careful here:
Report, onload event:

CommandBars("Form View Popup").Enabled = false

Report, close event:

CommandBars("Form View Popup").Enabled = true

Remember to re-enable or you'll have fits with other things!!!

[NeoPa]

An MDE or ACCDE database will not allow users to change the objects' designs.

This is very likely your easiest and safest course.

I suspect this is what Rabbit was referring to in his post.

[moonrb]

thanks

but can u tell me , how can i get data from an MDE file, when i make changes to the database by original MDB file.

i want to know the backup process from MDE file & restore process.

i have another problem, that is if i give the MDE file to a user, he can easily copy it and give it to others. How can i prevent this from happening

thanks

NeoPa & Rabbit

[zmbd]

but can u tell me , how can i get data from an MDE file, when i make changes to the database by original MDB file.

IF you make a design change to the database (ie. form, add a query, etc...) you must re-create the MDE/ACCDE file.
There is no way to reverse the process; thus, the requirement to keep a working copy of the MDB/ACCDB file.

i want to know the backup process from MDE file & restore process.

You do not go back from an MDE to a MDB. Keep a copy of the MDB file for development.

i have another problem, that is if i give the MDE file to a user, he can easily copy it and give it to others. How can i prevent this from happening

Normally, new question, new thread; however, this one is a short answer: You can not easily prevent this from happening.
There is nothing you can do that a smart user can not bypass in Access other than the MDB/ACCDB to MDE/ACCDE conversion (and even then, there are hex editors and some very savy blackhats that more than likely can still reverse engineer the application)
IF you want more ideas - new thread please.

[NeoPa]

As Z says, the conversion process is one way. You (and only you) keep a copy of your MDB/ACCDB file. You use this file to create an MDE/ACCDE file that you distribute to your users. This file is not one they can work on to produce other files as it has the design of objects (Forms and Reports) locked.

It's generally as usable for a user but simply cannot (ignoring hacker techniques) be used to produce new versions.