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

Limit interface to only reports

matthardwick
P: 19
Hello everyone,

Is it possible to force Access to only allow the Reports and Queries sections of the interface, I don't want to allow people to view/edit tables or create forms etc.

Boss woman wants to be able to create queries and reports but I don't want to give her access to the tables.

Is this possible?

Thanks.
May 29 '08 #1
Share this Question
Share on Google+
8 Replies


ADezii
Expert 5K+
P: 8,638
Hello everyone,

Is it possible to force Access to only allow the Reports and Queries sections of the interface, I don't want to allow people to view/edit tables or create forms etc.

Boss woman wants to be able to create queries and reports but I don't want to give her access to the tables.

Is this possible?

Thanks.
You can probably do what you are requesting by designing a Custom Interface that will display only Reports and Queries, while keeping the true Database Window Hidden and not allowing it to be displayed. I have the base code for something similar to this. If you are 'truly' interested, I'll take the time and attempt to modify it to suit your needs. If you are really interested and do not require an immediate solution, I'll be more than happy to attempt this for you. Let me know one way or the other.
May 30 '08 #2

matthardwick
P: 19
That would be good, although this is my project and I don't have any budget, so wouldn't be able to give you anything but gratitude for your time.

Would users be able to create their own new queries and reports?


Ta.
Matt
May 30 '08 #3

ADezii
Expert 5K+
P: 8,638
That would be good, although this is my project and I don't have any budget, so wouldn't be able to give you anything but gratitude for your time.

Would users be able to create their own new queries and reports?


Ta.
Matt
so wouldn't be able to give you anything but gratitude for your time.
Wouldn't expect anything else.

Would users be able to create their own new queries and reports?
Yes


NOTE: As soon as I get some free time, I'll see what I can do. We'll handle it step by step.
May 30 '08 #4

ADezii
Expert 5K+
P: 8,638
Just checking in, I should have something for you by Monday. I simply have not had the time to write the code, but as soon as I do, I'll let you know.
May 31 '08 #5

ADezii
Expert 5K+
P: 8,638
I found your request to be a little unusual, but interesting nonetheless. The following steps were taken in order to initiate this process:
  1. The Standard Access Interface (DB Window) has been replaced with a Custom Form (frmNewDBWindow). This Form provides the same functionality as the Database Window (Open, Design, New) but only has Tabs for Queries and Reports.
  2. The SHIFT ByPass has been disabled disallowing the User to access the Database in this manner.
  3. All Startup Options have been deselected (OFF), so the User cannot open the database Window via the F11 Key, Full Menus are not allowed, Shortcut Menus are not allowed, Built-in Toolbars have been disabled, etc. All this is designed to not allow the User to access the Standard Database Window.
  4. I allowed backdoor access via a SHIFT+CTRL+F4 Key combination (AutoKeys Macro). This unique Key Sequence will open the Startup Properties Dialog Box where you can select all Options turning them ON again. You will then have to exit the Database, and then open it again to get back to Normal operation. Remember to turn these Options OFF again when finished.
  5. All code has been encapsulated within frmNewDBWindow, so simply Open the Test Database, then Tools ==> Startup ==> Deselect all Options. Exit the Database so they can take effect the next time you open it.
Jun 2 '08 #6

JustJim
Expert 100+
P: 407
No that is a very handy thing. It sure beats taking a pair of pliers and pulling out the F11 key like a rotten tooth, which I've wanted to do a few times!

Well done.

Jim
Jun 2 '08 #7

matthardwick
P: 19
That is absolutly perfect.

Thankyou soooo much - it's perfect.
Jun 2 '08 #8

ADezii
Expert 5K+
P: 8,638
That is absolutly perfect.

Thankyou soooo much - it's perfect.
Glad you enjoyed it, have fun.
Jun 2 '08 #9

Post your reply

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