By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

How can i disable right click on report ?

P: 23
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.
Dec 24 '13 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,316
Give the user a compiled version of the database. But remember to keep an uncompiled version for yourself so you can make changes.
Dec 24 '13 #2

zmbd
Expert Mod 5K+
P: 5,287
This will stop other popups too so be careful here:
Report, onload event:
Expand|Select|Wrap|Line Numbers
  1. CommandBars("Form View Popup").Enabled = false
Report, close event:
Expand|Select|Wrap|Line Numbers
  1. CommandBars("Form View Popup").Enabled = true
Remember to re-enable or you'll have fits with other things!!!
Dec 24 '13 #3

NeoPa
Expert Mod 15k+
P: 31,186
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.
Dec 25 '13 #4

P: 23
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
Dec 25 '13 #5

zmbd
Expert Mod 5K+
P: 5,287
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.
Dec 25 '13 #6

NeoPa
Expert Mod 15k+
P: 31,186
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.
Dec 26 '13 #7

Post your reply

Sign in to post your reply or Sign up for a free account.