Access on VPN -- seeking solutions



My client wants to make their Access 2007 database available to
offices around the country with multi-user permissions set to control
access to the tables and forms, etc. The easiest thing would be a
client/server app, but they are concerned that accessing the backend
on their VPN would be too slow.

We've discussed the possibility of publishing the forms to the
intranet with ASP, but I'm concerned that web development with Access
is a complex and costly bucket of worms, especially given the multi-
user settings and the fact that I don't have any experience with web
development. I've also heard web development might be easier with SQL
server.

I've heard there may be ways to go the client/server route that would
avoid the speed issues with VPN, possibly involving RDP?

I would welcome any thoughts about how best to attack this project,
especially thoughts on how best to make the client/server work without
performance problems.
.



Relevant Pages

  • Re: remote server
    ... client/server. ... Unfortunately, I can't use VPN. ... > when it comes to working with a SQL server. ... >>> what is the best way connect to remote SQL server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: simple TCP/IP messaging
    ... I'll post some samples tonight. ... One is a working chat client/server that ... but doesn't support multiple connections. ... I use the MSWinsock control, ...
    (microsoft.public.fox.programmer.exchange)
  • RE: SBS2000 and L2TP/Ipsec VPN
    ... not client/server. ... regardless whether it's explicitly mentioned or not. ... XP and Win2K3 when they are the VPN endpoints. ... "Mike" wrote: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Computers joining customers domain - how to best configure
    ... At this stage I think I'm talking about allowing control of the local ... I have a client/server product that is sold to a number of customers. ... The server runs Windows 2003 Std and is in it's own workgroup. ... and are in the same workgroup and have the same local user accounts. ...
    (microsoft.public.windows.server.general)
  • Re: ghost 8 enterprise on sbs 2003 premium
    ... It's the client/server side of ghost enterprise that appeals (the ghost ... The ability to VPN in and manage all clients is awesome plus there is lots ...
    (microsoft.public.windows.server.sbs)