Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open database in another town

    Can i open the same database through internet in another town? I mean to set such a link as in the networks in our office? For the time being we send databases made with autoexec that unpack themselves in the other computers, but it would be fine if we work in real time. I was advised to build web interface but i do not know much about this.Could someone help me where i could start from and what is the easiest way ?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open database in another town

    Hi there

    This is a many facetted question!

    1) Am I to assume that you are using Access at the moment?
    2) Is it a local network (just in the one office)?
    3) How many users would want to access the database?
    Jerry

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Open database in another town

    Is this an Access MDB file? You would not want to use Access to work with a file over a slow link, and that includes using a local database linked to tables in a remote database. It's tolerable inside a local area network because your traffic travels at around 100,000 Kbps. However, over the Internet, you would be lucky to achieve 1,000 Kbps, about 100 times slower. This is why a web interface, having all of the queries and reports generated on the remote server and delivered as a simple web page, usually is the best solution for real-time access. Of course, you need to consider security issues because thousands of computers will discover your database site within a few days and you need to be ready for them. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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