David M C said:
Having read:
http://www.access.qbuilt.com/html/multiuser_applications.html
It suggests not to use Domain Aggregate Functions in a multi-user
environment. I use DLookup's and DSum's quite a lot. What would be the
alternative to these?
What Tom says is,
<QUOTE>
In queries that involve linked tables, avoid using VBA functions in
query criteria, especially domain aggregate functions, such as DSum,
anywhere in your queries. When you use a Domain Aggregate Function,
Access may retrieve all of the data in the linked table to execute the
query.
</QUOTE>
Note that he's specifically talking about using these functions *in
queries*. I don't believe he's talking about not using the functions in
form code, module code, etc., at all. What he's cautioning against, I
believe, is writing queries that use domain aggregate functions in
calculated fields and criteria. For example, a query like this:
SELECT Field1, Field2 FROM MyTable
WHERE Field2 = DMax("Field2", "MyTable");
will be extremely inefficient.