User access to query design from a form

[nq]

I have a database that has a variety of reports for the users. These reports satify all the current needs of the users. However, I have a couple of users that have sufficient Access knowledge to create their own queries.

I do not want to give them access to structure, table or form design.

Is there any way of giving them access to query design with "a click of a button". ie click a button on a form and the standard Access query design appears. They could then select tables and construct a specific query.

Nigel

 

[lupins46]

Create a separate database with links to the tables.
Convert it to an mde.

This will allow them to create queries and nothing else.

Of course, queries can still wreck the data!

 

[ZmrAbdulla]

[tt]DoCmd.RunCommand acCmdNewObjectQuery[/tt]
can bring the wizard to create a new query.
After that you need to delete the query otherwise you will be having plenty of queries after a period.

[tt]DoCmd.DeleteObject acQuery, "NewName"[/tt]
can delete a query. But you need to specify the query name.

May be some one having another solution to run an sqlquery without saving it into the DB.
There was addins do this I don't exactly remember.


________________________________________
Zameer Abdulla
Visit Me
Minds are like parachutes. They only function when they are open. -Sir James Dewar (1877-1925)

 

[nq]

Zameer

Thank you. Just what I was looking for.

Nigel.