Using VBA to start QueryWizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access application where we have locked out the display database
window via startup settings for security. I need users to be able to create,
save, modify queries against the database. These would all be select
queries. I have not been able to figure out how to make this available using
VBA and application menus.

Any help with this will be greatly appreciated.
 
Hi, Gordon.

To create new queries, try:

RunCommand acCmdNewObjectQuery

In order to modify existing queries, your application needs to provide the
list of QueryDef objects that are normally listed in the Database Window.
This can be a list box or combo box, but you'll need to use VBA code to fill
the displayed list (or use a query for the RowSource Property), open
selected queries, and save any changes the user makes.

This can be a lot of work. It might be easier to create an MDE file of the
database front end to place on each user's workstation which links to the
tables in the backend on a shared network drive, and allow the users to use
the Database Window and custom toolbars and menus to create, rename, modify
and delete any of the objects in their own copy of the database
application -- as allowed within the limitations of an MDE database file.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top