Limit interface to only reports

[matthardwick]

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.

[ADezii]

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.

[matthardwick]

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

[ADezii]

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.

[ADezii]

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.

[ADezii]

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.

[JustJim]

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

[matthardwick]

That is absolutly perfect.

Thankyou soooo much - it's perfect.

[ADezii]

That is absolutly perfect.

Thankyou soooo much - it's perfect.

Glad you enjoyed it, have fun.