Solved

Accessing Database through GoToMyPc

Posted on 2013-06-21
5
413 Views
Last Modified: 2013-07-11
Tomorrow I want to try to work from home (not go into the office). I was hoping to access the access table through GoToMyPc. Is this a reliable form of accessing the database?

The alternative is to take backend tables home on a usb storage unit and then Monday mornings replace it before anyone else comes into the office. Note: noone else will be accessing the database over the weekend.

Any thoughts on this would be great. Thanks for your help!

Chris
0
Comment
Question by:cansevin
  • 2
  • 2
5 Comments
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
When you use GoToMyPc, unless something has changed, you are "on" the PC you connect to, so yes there's no problem.  It's just as if you were sitting there in the office.

 Only KVM (Keyboard, Video, and Mouse) is going back and forth.

  If you're using some type of VPN through GotoMyPC (Teamviewer allows that for printing) and firing Access up on your station and then trying to get to the data on the remote PC, then no, that's not a great idea.

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
I use logMeIn, there is a free version as well as a Pro version that allows you to do file transfers.
0
 

Author Comment

by:cansevin
Comment Utility
Thanks... I am trying to use LogMeIn. It is working properly and I can see the computer screen.

How do I tell access to link to the table through LogMeIn? When I go through "Linked Table Manager" I can't find a way to access the computer that is connected through LogMeIn. Any idea? Thanks!
0
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
Comment Utility
I'm not sure what you mean.

When I log into LogMeIn from my laptop and connect to my PC, then I'm working from my PC, and have access to all the same functionality as if I was sitting at that PC.  But I've never tried to reconnect a linked file so I'm not sure whether you would have access to network drives from the remote desktop.

Dale
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
Comment Utility
<<How do I tell access to link to the table through LogMeIn? When I go through "Linked Table Manager" I can't find a way to access the computer that is connected through LogMeIn. Any idea? Thanks! >>

 As Dale has said, LogMeIn is just like GotoMyPC; it's a remote control product.

  When you use it, it's just as if your sitting at the remote PC.  If you start Access up, your starting it up on the remote computer, not the one your currently sitting at.

  Most remote products work this way.

  The other way to work is to have a VPN (Virtual Private Network) connection to a remote network.   When you do this, then you would be running Access on the PC your sitting at and data would actually be moving across the connection.  Re-linking tables in this case is required.  LogMeIn Hamachi does this and as I mentioned, TeamViewer also has a VPN connection option.  There's also a VPN client built-into windows that you can use.  All these however take a little more effort to setup.

  But with Access and using JET as a datastore (your data is in a MDB file), the first option is always the best.   The drawback however is that you tie up the PC that your remotely controlling; no one else can use the PC while your doing so.

  That's not true with the second option where you just get a connection to a network.

Jim.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now