I created some Access databases for some of my remote colleagues. I would like to find out how I can help my colleagues by looking at what they have done incorrectly online so that I can fix it without having to ship the database back and forth.

Access Remote solution

While access has replication and synchronization features that you might consider adopting, I'm wondering if a remote solution might not be the easiest option. There are all kinds of remote technologies available that allow you to sit at your desktop anywhere in the world, log on to your colleague's computer, and take control of their desktop. Not only can you explore their Access database as if you were sitting at their workstation, you can also show your colleagues exactly what they did wrong and how to prevent it from happening again. Instead of fixing the problem on your end, you will be helping your colleagues learn the ins and outs of using your database the way it is meant to be used.

Try Windows remote first

Depending on the various operating systems involved, you may be able to use the remote capabilities of Windows to accomplish this. For example, if both users have Windows Vista or XP, you can use Remote Assistance. This involves a little cooperation on both ends. First, your colleague will need to enable Remote Assistance connections on their computer which is done by going to the Control Panel, clicking System, clicking the Remote tab, and enabling Remote Assistance.

Sending invite for Remote Assist

Next, they need to "invite" you to help them. This is done by opening Remote Assistance and issuing an invitation, usually in the form of an e-mail. Once you receive the invitation, you can act upon it and establish a connection. Both you and your colleague will be able to see the desktop while you control it. When connected, give your colleague a phone call so that you can talk as you work.

Remote Connect products

If Windows Remote Assistance isn't an option, other remote connection products are available. For example, I used to use Symantec's PC Anywhere to connect to computers located at branch offices. Both computers need a copy of the PC Anywhere software installed and, again, there's a bit of coordination involved to establish remote connections. Once connected, you see the remote desktop and can control it as if you were sitting at the workstation. Your colleague can see what you're doing. A text chat feature is handy, too, though you may prefer talking over the phone.

Other online tools allow for collaboration as well though they may not be suitable for a large, multi-user Access database.

Celeste Stewart | September 24th, 2008
Tags: db access remote, remote access database, remote connection
Categories: Remote PC Help

You can leave a comment, or trackback from your own site.