Data Access via VPN

I have an app that originally was used on a LAN. It is now being used
not only over the LAN but also through a VPN.

The app is very recordset intensive and uses Access as the database.
By recordset intensive I mean many calls to the database tables for
seaching and looking up various data.

As might be expected, the program grinds to a snails pace when running
through the VPN even though it is lightning fast over the LAN.

I am thinking of trying to make a server/client app whereby the client
on the work station sends a request to the server on the server
computer and the server simply returns the relavent data to the
client.

In my mind I see the "Request" consisting of Properties and a Method
which the server would act upon then send the Response which would
consisting of "Properties" which would be evaluated and used by the
client.

Since this has to be a very common issue there must be a standard
solution to the problem.

My question is:
If there is a standard solution, what is it?
If not does anyone have any suggestions as to how I can make this
work?
Is DCOM the answer?

Again thanks to all those that reply.

Richard

.

Relevant Pages

  • Re: vpn access from hotel room
    ... If you have a dedicated workstation on the LAN (or just access to any LAN ... users to keep all their data on the server so it's ... A VPN requires significantly more bandwidth ... If you're laptop has been joined to the SBS domain, ...
    (microsoft.public.windows.server.sbs)
  • Re: Routes
    ... succeed with the original requirements because it won't limit LAN access to the ... access to only the Terminal Server by using something like ISA,...once the user ... I will allow full network access to the VPN clients. ... terminate at the servers and no further into the LAN. ...
    (microsoft.public.windows.server.networking)
  • Re: Horrible VPN Performance
    ... Comment vis a vis running websites on SBS. ... VPN implementation in Microsoft software and talk to the ... > server database to scrap. ... which uses a workstation on the LAN running ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem accessing PCs when connected using VPN
    ... I can't however access or ping any other computer on the LAN other than the server. ... The problem arises when a workstation connected to SERVER01 via a VPN connection tries to access the shared folder on SERVER02. ... Yet when the same client connects using the LAN directly, it can access the same shard folder on SERVER02 perfectly well. ... Have you enabled routing between the 2 subnets? ...
    (microsoft.public.windows.server.networking)
  • Re: ICS quandary
    ... and RRAS allows interfaces to be created as ... i.e. a demand dial vpn. ... my LAN (3 XP pro, a 2k server domain controller, and a redhat 9). ...
    (microsoft.public.win2000.networking)
Loading