Dynamic queries

[John]

I have a set of dynamic queries built in VBA using
CreateQueryDef based on what gets selected on a form
(where clause). I also have a set of static query to be
joined with the dynamic query and the resulting join is my
recordsource for my report. The issue is in a multi-user
environment, the dynamic queries will get overwritten by
different users depending on what was chosen. Any ideas on
how to resolve this? Thanks in advance.

 

[Gary Miller]

John,

If you are using this db in a multiuser environment, you
really should have the db split into a front end / back end
setup. If this were the case, you would not be having this
problem as the queries will live on the individual user's
machines. Your performance will be much better over the
network as well as a host of other reasons to do this.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________