having one linked table slows everything

[Joss]

There are many posts relating to slow performance and linked tables, but
none seem to answer this query.

Why is it that as soon as I put a linked table into the .mdb (linked
through
Broadband VPN to another .mdb) the whole thing slows down. Even opening
Access 2000. I have tried changing the subdatasheet name on the remote table
(table being linked to) to 'none' but this hasn't made a difference.

thanks for help,
Jo

 

[Douglas J. Steele]

It's not really appropriate to attempt to use Access across a VPN
connection: it's just not fast enough.

You might want to read what Albert Kallal has to say about using Access over
the WAN at http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

 

[Tom Wickerath]

Joss,

Read Albert Kallal's paper and see if this answers your question:
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html


Tom
_________________________________


There are many posts relating to slow performance and linked tables, but none seem to answer this
query.

Why is it that as soon as I put a linked table into the .mdb (linked throughBroadband VPN to
another .mdb) the whole thing slows down. Even opening Access 2000. I have tried changing the
subdatasheet name on the remote table (table being linked to) to 'none' but this hasn't made a
difference.

thanks for help,
Jo

 

[Joss]

thanks. Tried the trick with creating the permanent link with a bound form
and that worked wonders. Also, learnt about upsizing and it seems that may
be even better. Question about that in subsequent posts......!

Jo