MS Access Multiuser - More efficient - query or form "Where Conditions?"

Author

More efficient - query or form "Where Conditions?"

rgrantz

2005-04-06, 8:06 pm

This question probably advertises my ignorance, but I'm trying to make sure
I have as efficient as possible db app. for multiple users and network
traffic, etc.

I have a split db, with front end on every user's PC, and back end on shared
folder. I'm putting in all kinds of "click on this field to open another
form with related data about that record" stuff on the forms. I'm wondering
which is more efficient (or if there's a difference):

- Using a separate query whose one field (the one clicked on in the first
form) is set to = the 1st form's field value, thus populating the second
form with related data

OR

- Using a Where condition in the button's OpenForm event to filter the
second form's data

So, the record source for the 2nd form would either be a query specific to
that 2nd form, or a table (or larger, more universal query) whose results
are filtered using the Where Condition in the DoCmd.Openform line.

Any advice is appreciated on this, and thanks for reading.

Tony Toews

2005-04-06, 8:06 pm

"rgrantz" <rgrantz@hotmail.com> wrote:

>- Using a Where condition in the button's OpenForm event to filter the
>second form's data

This is all I've ever used. One client has a BE MDB with hundreds of
thousands of records in about five or seven tables. Performance is
fine.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

david epsom dot com dot au

2005-04-06, 8:06 pm

When I compared methods some time ago, they all seemed
to come out about the same. For consistency, select a
method you feel comfortable with, and stick to it.

(david)

"rgrantz" <rgrantz@hotmail.com> wrote in message
news:3ae7hbF690aopU1
@individual.net...
> This question probably advertises my ignorance, but I'm trying to make
> sure I have as efficient as possible db app. for multiple users and
> network traffic, etc.
>
> I have a split db, with front end on every user's PC, and back end on
> shared folder. I'm putting in all kinds of "click on this field to open
> another form with related data about that record" stuff on the forms. I'm
> wondering which is more efficient (or if there's a difference):
>
> - Using a separate query whose one field (the one clicked on in the first
> form) is set to = the 1st form's field value, thus populating the second
> form with related data
>
> OR
>
> - Using a Where condition in the button's OpenForm event to filter the
> second form's data
>
> So, the record source for the 2nd form would either be a query specific to
> that 2nd form, or a table (or larger, more universal query) whose results
> are filtered using the Where Condition in the DoCmd.Openform line.
>
> Any advice is appreciated on this, and thanks for reading.
>

Sponsored Links