VPN and Access is not a good or clever idea....
is there a difference when on a local network is the app always slow, irrespective of which computers are using it
how clogged is your current network
are you using bound or unbound controls/recordsets. if you don't know the difference then you are using bound controls/recordsets
can you identify if its specific sections (actions) or forms or reports that are slow. it may mean that elements of those forms & reports may need re desigining
are you making a lot of use of domain functions in report DETAIL.. that will be slow
you may need to think about caching static data inside the local copies
do you know where the time is being consumed
if you have a slow network connection and are using bound controls for things like list boxes then soemtimnes these can get populated 3 times between a form opening and displaying. this is a real problem with combo/list boxes that have lots and lots of rows (and columns in them
make certain your queries are returning only the columns you need (eg only stuff the coilumns you actually need into a list/combo box and pull other values from the relevenat table based on a selection in the combo box. its tempting to occasionally stuff other data that you will need evetnually in a list/combo as hidden columns.
whenever youcreate a form or report make cdeertaint he query returns only the data actaully required
switch on the EXPLAIN / show plan function
that reference also helpfully brings up the following link
I'd rather be riding on the Tiger 800 or the Norton