Remote Deskptop connection to Access DB on Server

[Curious]

Remote Desktop connection to Access DB on Server

Hi

I currently have an Access Database in a BE/FE, server/client LAN architecture at a single office location. My client would like to allow one user to 'add new records' to the database on the weekends (i.e. after hours), without needing to come into the office.

From my research, it seems I can setup Remote Desktop to connect from the client's home PC directly to the server PC, across the internet, using Windows XP Professional on both computers.

Is it that simple, or should I be considering other things?

 

[John.Woody]

Its that simple... as long as you have a fixed ip address at work or sign up for a dns forwarding service. You also need to control the router to allow traffic through the router to the correct PC.

 

[Curious]

Thanks John.Woody,

The company has a static/fixed IP address with their ISP.

Can you explain this a little further:

You also need to control the router to allow traffic through the router to the correct PC.

I've also had secondary thoughts about security. Instead of accessing the db on the server machine, perhaps I could have them access, through remote desktop, one of the FE client machines, that will then access the BE on the server.

Will DB access across the LAN, through remote desktop, act the same as being on the local FE machine, and accessing the BE on the server through the FE?

 

[pbaldy]

I manage a number of Access applications for a remote office, usually by connecting via RDP to a PC on their network. You should have no problems with that setup.

 

[John.Woody]

Try looking at this
http://theillustratednetwork.mvps.org/RemoteDesktop/RemoteDesktopSetupandTroubleshooting.html

 

[Curious]

Thanks so much John.Woody!

That tutorial is excellent. It's got so much information and easy to follow screen shots. I think I'll be able to follow it.

Now I've just got to find the time to do it.