Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Remote Access (Access XP)

    Does anybody know of a different (much faster) way of operating an Access database than via PC Anywhere?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remote Access (Access XP)

    There is no such product, Pat. Remoting Access means dragging every query, combobox source, lookup table, and subdatasheet kicking and screaming across the connection. Terminal Services might be an alternative, but you didn't offer any detail in your question, so I don't know whether that's a possibility for you or not.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Remote Access (Access XP)

    Actually, PC Anywhere and Windows Terminal Services both work on the same general principle. You send keystrokes and mouse moves and clicks to the server, and it sends back screen images to you. Neither are really acceptable using a dial-up modem. On the other hand with DSL or other broadband services (256Kb or faster), either work reasonably well. We actually do design work and support of two clients about 1000 miles away using Terminal Services. It isn't quite as responsive as being on their site, but it is viable.

    We have also tried other approaches, such as putting a front-end on the local workstation, and then connecting to tables in a back-end using VPN, Remote Access, etc, and none of them are workable, even over a 1.544 Mbit connection.
    Wendell

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Remote Access (Access XP)

    The subject "Remote Access" was an attempt to describe in a couple of words what I was trying to accomplish, hence the reference to PC Anywhere.

    I am after a solution that users can operate an Access database remotely, ie. over a Dialup (very slow) or some kind of connection (Broadband, say).
    Broadband seems a quicker solution, does that mean the remote users need a broadband connection?

    What is DSL all about? Wendell mentioned this in his post.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remote Access (Access XP)

    DSL is a kind of broadband service. The kind of broadband you get depends on what is available in your are. And yes, the remote users would need broadband service because otherwise, they're going to watch the screen draw one line at a time, and the risk of corruption or just lost of connection will be unacceptable.
    Charlotte

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Remote Access (Access XP)

    Thanks Charlotte.

    Yes I know what screen painting one line at a time is like, I used PC Anywhere at some stage in the past with a remote client.

    Does that mean that broadband will be a lot faster, something that the users would accept.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remote Access (Access XP)

    Broadband is a lot faster than dialup. Whether users will accept it over a remote connection is something else again. Access wasn't really designed to be used like this, and Jet is notoriously inefficient accross connections like that. Also, broadband services run at different speeds depending on the service and your location, so I doubt there is a definitive answer to your question. A great deal depends on how the application is built in the first place and how it is used.
    Charlotte

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Remote Access (Access XP)

    What I was considering was that users would select a particular frontend that resides on the server, the backend would also reside there.
    So the user would access the database via their frontend that resides on the server, not on the users remote PC. If this was the case then they could use PC Anywhere over a broadband connection. This should then be acceptable to the user as the only traffic would be the screen stuff only.

    Am I right in all this or am I thinking pie in the sky.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remote Access (Access XP)

    I haven't tried it, Pat, but it sounds like you're reinventing Terminal Server or Citrix. Maybe Wendell will chime in with his wisdom on those topics.
    Charlotte

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Remote Access (Access XP)

    I hadn't thought of Citrix, this was used on a client site I was at a couple of years ago. If you had a broadband connection this would be the way to go, because the users want an acceptable response.

    What is Terminal Server, is it anything like Cirix or PCAnywhere?

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Remote Access (Access XP)

    Windows Terminal Services is a feature of Windows 2000 Server or Windows 2003 Server - the latter has much nicer bells and whistles. We especially like the SBS 2003 version, as you get SQL Server with it. We use this feature with a client in Tacoma, WA, which is about 1000 miles from Denver. It or Citrix are the most workable things we found when trying to work with a remote Access database. And we do split the front-end away so that each remote user has their own copy. Let me know if you have more questions.
    Wendell

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Remote Access (Access XP)

    Thanks Wendell, when you talk about Citrix and splitting the database into a FE/BE where the user has their own copy, where does this FE reside? It doesn't reside on the users PC, does it? It would reside on the Citrix server, wouldn't it?

  13. #13
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Remote Access (Access XP)

    Yes - the front-end would reside on the Citrix or Terminal Services server. But each user login would have their own copy to work with - that solves all sorts of problems that you run into when users try to share a front-end.
    Wendell

  14. #14
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Remote Access (Access XP)

    You also might want to check-out GoToMyPC. This essentially would work like a terminal server situation, in which everything takes place on the host.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  15. #15
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Remote Access (Access XP)

    Where do I look for GoToMyPC?

Page 1 of 2 12 LastLast

Posting Permissions

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