odbc over internet

We are running an sql server database on a Windows 2000 server, aproximately
15 clients on our lan use odbc connections to connect with acces 2002 front
end. No problem. Then i came up with the idea to connect a home-worker via
internet, using a vpn tunnel over isdn. Somehow this vpn-over-isdn
connection is unstable, as a matter of fact only few records can be entered
before the connection is lost. Is this a limitation of odbc connections or
just a miserable isdn solution wich need to be replaced?"b.binnenweg" <bobby01@.nospamxs4all.nl> wrote in message
news:402e0d12$0$557$e4fe514c@.news.xs4all.nl...
> We are running an sql server database on a Windows 2000 server,
aproximately
> 15 clients on our lan use odbc connections to connect with acces 2002
front
> end. No problem. Then i came up with the idea to connect a home-worker via
> internet, using a vpn tunnel over isdn. Somehow this vpn-over-isdn
> connection is unstable, as a matter of fact only few records can be
entered
> before the connection is lost. Is this a limitation of odbc connections or
> just a miserable isdn solution wich need to be replaced?
>
That sounds like a connection issue... are you experiencing high latency
from the client to the server? Also, linked Access tables are not that
efficient and not recommended for WAN access.
Steve