G
Glenn
Hi
a somewhat confusing subject line at best, I admit.
Let me explain:
-a multi-user database split front/back end (access 2000)
-on a form, a listbox has a query as rowsource (fe select Name from
tblCustomers)
the form with the listbox is opened and the dropdown list shows the
current names.
-the backend table tblcustomers is modified by another user (using
another copy of the frontend)
-> the listbox will not show the modifications unless the form is
closed/reopened or the listbox is explicitly requeried by code.
----------------------------------
I am worried that the performance of the application will suffer if I
hardcoded a requery with each relevant user operation.
the real production form has 8 of such listboxes and sometimes complex
queries.
Furthermore, a requery each and every time is overkill, because most of
the time the underlying data wouldn't have changed.
Ideally, I could check the last modification date of tables.
But with what I've read about the .lastmodified property on the web,
that isn't. (my access help is corrupted again)
any suggestions?
glenn
a somewhat confusing subject line at best, I admit.
Let me explain:
-a multi-user database split front/back end (access 2000)
-on a form, a listbox has a query as rowsource (fe select Name from
tblCustomers)
the form with the listbox is opened and the dropdown list shows the
current names.
-the backend table tblcustomers is modified by another user (using
another copy of the frontend)
-> the listbox will not show the modifications unless the form is
closed/reopened or the listbox is explicitly requeried by code.
----------------------------------
I am worried that the performance of the application will suffer if I
hardcoded a requery with each relevant user operation.
the real production form has 8 of such listboxes and sometimes complex
queries.
Furthermore, a requery each and every time is overkill, because most of
the time the underlying data wouldn't have changed.
Ideally, I could check the last modification date of tables.
But with what I've read about the .lastmodified property on the web,
that isn't. (my access help is corrupted again)
any suggestions?
glenn