Allowing Users to Run Queries Without Showing the Database Window

  • Thread starter Thread starter Drahala via AccessMonster.com
  • Start date Start date
D

Drahala via AccessMonster.com

I have an access front end that connects to a SQL backend, and is designed in
such a way that the users never see the database window or default access
database menu bar, only the forms and menus that I want them to see.
Specifically:

1. I have set a startup form

2. I have a personalized shortcut menu bar

3. I have disabled the bypass key

4. I have disabled all keystrokes not used by my application in the form
open event

5. I have unchecked the following option in the startup:
* Display Database Window
* Display Status Bar
* Allow Full Menus
* Allow Default Shortcut Menus
* Allow Built-in Tool Bars
* Allow ToolBar/Menu Change
* Use Access Special Keys

I want to know if it's possible to keep this configuration but allow the
users the ability to create and run adhoc access queries against back end
views, and allow them to export the results to an excel spreadsheet.
 
No. What I would suggest would be to create another database with the tables
linked and allow them to build their own queries or reports.
 
That's what I thought. The second database is plan B, but it would be much
cleaner if this function could be managed in the same front end. Thanks for
the quick response.
No. What I would suggest would be to create another database with the tables
linked and allow them to build their own queries or reports.
I have an access front end that connects to a SQL backend, and is designed in
such a way that the users never see the database window or default access
Click to expand...
[quoted text clipped - 22 lines]
users the ability to create and run adhoc access queries against back end
views, and allow them to export the results to an excel spreadsheet.
Click to expand...
Click to expand...
 
It would be nice. I think we all have had this challenge before, but a
database is either secure or it isn't.
--
Dave Hargis, Microsoft Access MVP


Drahala via AccessMonster.com said:
That's what I thought. The second database is plan B, but it would be much
cleaner if this function could be managed in the same front end. Thanks for
the quick response.
No. What I would suggest would be to create another database with the tables
linked and allow them to build their own queries or reports.
I have an access front end that connects to a SQL backend, and is designed in
such a way that the users never see the database window or default access
Click to expand...
[quoted text clipped - 22 lines]
users the ability to create and run adhoc access queries against back end
views, and allow them to export the results to an excel spreadsheet.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top