Access 2000 Query and VBA 1

[tmadhavi62]

Hi,
I have a form with a command button. When I click the command button a query already existing should open and also the user should be able to see the show table box without going to the menu query--Show table or without doing a right click

I know I can open a query using the docmd.openquery but how do I get the second part.
Also is there anyway I can secure a query so that users of the database can't edit or delete that query?

Thanks,
Madhavi

 

[egobbitz]

You can use the following

docmd.runcommand acCmdShowTable




Nick

 

[tmadhavi62]

Hi egobbitz,
Thanks for the help. It worked for the show table part. Do you have a suggestion for the second part of my question to have a query template in the database which users can't delete or edit.