Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Location
    British Columbia, Canada
    Posts
    29

    Unanswered: Access database through internet

    My client would like to have the Access database I've built accessible through the internet. Is there a standard or a de facto standard for technologies to do this? I've been trying to set up a VPN, but the software included with Windows Vista seems quite finicky, and I haven't been able to get it up.
    nfw04 uses Access 2007

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds so easy doesn't it?!

    I can't tell you how many times I have consulted with clients and I ask them if they need their application to go online and they say NO and I remind them that if they want an Internet based solution later, the application needs to be re-written in something like PHP/MySQL and NOT Access, so you can't change your mind later without a total loss... they still say no, they don't need it to go online.

    I then develop their application in Access.

    Then they say "ok, that's great!! Now let's just put this online so we can access it from anywhere and we're done".

    I remind them about what was said initially and no doubt they get upset disappointed that they can't just "upload it" somewhere.

    So, if you do find a good solution to running an Access database over the 'net, please let me know!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2009
    Location
    British Columbia, Canada
    Posts
    29
    Is this really true? Doesn't a VPN connection simulate a LAN?
    nfw04 uses Access 2007

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    VPN <> Online. If you only want a WAN/VPN connection, then that's a whole different story!

    The best solution I've seen yet is Terminal Services, but barring that, yes it's true.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Oct 2009
    Posts
    340
    hey folks, Access is designed for local installation i.e. LAN. One can extend it via Terminal Services (Citrix) if there exists a solid private network. One doesn't enter into the world of Terminal Services lightly and so you would have it in a large corporate network and its used for a variety of applications. This is also, by the way, now becoming the area of SharePoint too.

    Alternatives are few; one can do a Remote Log On. There are commercial services out there like GoToMyPC.com and others - they work pretty good. But you have to have your PC turned on at your office. And there is a noticeable latency/lag.

    Another alternative is AccessTables.com; they will replicate the tables so they are shared. The good side of this is that the database runs locally in all locations - so it is fast. But the intent is that the database tables get consolidated/replicated once or twice a day - - so it isn't for real time data sharing between locations if that is needed.

    Have done all of these options. If the data consolidation/sync is ok to occur once a day (typically overnight) - I default to AccessTables.com because it is simple and the local running of the database is preferred by users. But every situation is different.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •