Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Off Site Connection

Discussion in 'Information Technology' started by Peter, Nov 14, 2005.

  1. Peter

    Peter
    Expand Collapse
    Guest

    Hello all hope you can give me some help in this area.

    I have a small peer to peer network running between computers at work with
    one computer designated as the data server. Get data from that computer to
    run Access on other computers in office and works fine. What I want to be
    able to do is access that data from outside the office. Have installed a
    linksys VPN router with a highspeed connection and static IP address. Can
    connect to the VPN router and computers on the network with a little hassle,
    but seems to work fine for working on word docs but will not open Access
    files even though the server is a mapped drive through the VPN connection.
    After looking on the site here I see that using the VPN is not the way to go
    for Access, so what I'm looking for is the best way to do what I want, work
    on access files from outside the office. I can always use a computer on the
    office network as a host so if PC anywhere or something like it is the way to
    go I can make that change. Just not all that sure about PC Anywher although
    its been a few years since I used it and that was an old dial up connection.

    Appreciate any ideas and suggestions you can give me. My over all goal is
    to be able to work on all my software from outside the office just like I was
    in the office.

    --
    Thanx
     
  2. Loading...


  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Peter" <Peter@discussions.microsoft.com> wrote:

    > I can always use a computer on the
    >office network as a host so if PC anywhere or something like it is the way to
    >go I can make that change. Just not all that sure about PC Anywher although
    >its been a few years since I used it and that was an old dial up connection.


    If the host PC is Windows XP you can use the built in Remote Desktop function. On
    the host PC Control Panel >> System >> Remote tab >> Remote Desktop section. Note
    that you will have to open the corp firewall to allow incoming traffic to that PCs
    TCP/IP port. Or get some other method of getting to that PC.

    Note that for multiple PCs accessing the network you'd want to use Terminal Server.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    The suggestion by Tony to use remote desktop is a great solution, and one
    that I 2nd...


    I explain more why you can't use the VPN for ms-access here:
    http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

    And, the above article assumes you split your database. If you have not
    split you database, then please read the following article BEFORE you read
    the above one!!

    http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     

Share This Page