Hi all,
I have a general question and a specific problem.
We make extensive use of amatuer Access97 dbs at work over NT4 but have
restricted access as we are forbidden to cross over a LAN. Can someone
explain, or point me to websites, about good network practice in terms of
loading forms based on tables, running queries that either return large
recordsets or perform aggregate calculations on large recordsets - to my
mind even though the calculations might be quite fierce, only a few 'totals'
actually come over the network(?) How can the network traffic/effects of
running the database be measured?
Following on from the above, I am trying to utilise user forms (in Outlook
preferably) to enable data gathering, but would like to import this data
into the db. Ideally en bloc, but certainly not by re-typing the actual
data! Is this possible? Or for example, could I go back to my boss and say a
form set for 'data entry only' is safe as houses when it comes to crossing
FAPS & LANs?
Any pointers or words of wisdom will be pursued vigorously.
Many Thanks,
Paul Wagstaff.