Solved

Accessing Database through GoToMyPc

Posted on 2013-06-21
5
424 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
ID: 39266024
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)
ID: 39266265
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
ID: 39267306
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
ID: 39267380
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
ID: 39267920
<<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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

867 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

16 Experts available now in Live!

Get 1:1 Help Now