Query builders??- this would be excellent

[LDG1234]

Hi Guys

This is an interesting one for you.

All my users only have access to the forms that I specify in my own security and they can't see the Database Window on startup.

My DB holds stacks of info and every other day someone asks for a new report or query.

IS there something out there which will let them build their own select queries, i.e a specific form or is there anyway I can build one so that they extract data of their choice on and adhoc basis.
They must only be allowed to select data for reports and not be able to update the main data table.

If any one out there can help me or point me in the right direction I would be very very grateful as it would save me soooo much time.

Thanks in advance for your time

Lloyd Gozzett
Process Developer

 

[Maquis]

The easiest way to do this would be to build a 2nd database which is completely blank and link to the tables in your database. I believe there is some way to make those links read only, but I don't know how to do it off the top of my head.

Your users now have access to the data in order to make their own reports without touching the design of your database. Maq B-)
<insert witty signature here>

 

[JimHorton]

Lloyd,
You can give them Read Only access to the tables, and in Security/Permissions, you can give administer permissions on <New Queries>, (at the top of the list). Even if they try an update, insert, or delete, they wont' have permissions on the tables.
--Jim

 

[JimHorton]

...Lloyd,
If you are still hiding the db window, you can put a button on a form where they can click and you use the CreateQueryDef method. Give them a textbox where they enter a name, then you can default the sql to Select * from SomeTable. Then call docmd.openquery QueryName,acViewDesign. Then they should have the menu option available to add table

If you set up security well, then you should be able to show the db window with no worries, this is what I commonly do, so they can create their ad-hoc stuff without me having to code it all behind the scenes.
--Jim