Query design in Access Runtime?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SP - 20 Dec 2004 12:49 GMT

I am deploying various .mdb's for use on Runtime machines but I would like
the give the users the ability to create/amend queries and reports.
According to some reports I have read, the design of any Access object is not
available to Runtime users without additional customisation. Could anyone
advise me as to how I can customise my database to allow this? I have aready
tried the "docmd.openquery..." method but this doesn't work in Runtime.
Thanks in advance.

Reply to this Message

Hansford cornett - 29 Dec 2004 20:27 GMT

Build the db and then just place it on a Local Server where everyone has
access to it and can create their own shortcuts to it. This way you have a
single db that everyone access the same data and can build and change codes
etc.,. Only problem is that the individual building a new query must have
exclusive access to make any changes. Sometimes it is easier for the
devolper to develop a query that is generic enough that it will cover the
situation. Another idea is that several queries are built and they are
accessed through a form using a drop down combo box and the correct query is
accessed through this drop down (LIMIT TO LIST) so it can not try to access a
query that is not available.

> I am deploying various .mdb's for use on Runtime machines but I would like
> the give the users the ability to create/amend queries and reports.
[quoted text clipped - 3 lines]
> tried the "docmd.openquery..." method but this doesn't work in Runtime.
> Thanks in advance.

Reply to this Message