working with remote users

[Rob Bunocore]

I have 5 users using a database remotely. They all work from home
and/
or out at the client. The never return to the main office which is
just someone's house.

We have set up a system to collect the data they are entering into
the
system. I wanted a way to let them share lookup tables through the
internet. Does anyone know how this might be handled?


Also, does anyone have a good method for notifying the user that
there
is an update? Right now the users update the system by downloading a
new version through FTP. I was hoping for a way that when they open
their version, it checks to see if there is a newer version.


Robby

 

[Arvin Meyer [MVP]]

You can use Access replication, or use a web interface, or use terminal
services such as WinConnect:

http://www.thinsoftinc.com/products.aspx

If only 2 people ever need concurrent connectivity, you can use the built in
RDP in Windows.

 

[Guest]

For the remote access issue you might want to check out the service offering
of GoToMyPC.com I don't mean to be a commercial for them - but it has
worked for me. Not sure about 5 simultaneous users off hand but you can
review their stuff online to see about that.

As for the update question; if you are the person making the update then
you could put a notice on the entry screen..... if you mean in regard to a
data entry made by a user - then you want to code something that might
trigger a message box - not sure.....

 

[David W. Fenton]

You can use Access replication,

Never a good idea when the locations are fixed and have Internet
connections (full-time or not) available, as well as when there's a
central location that could be running Terminal Server.

or use a web interface, or use terminal
services such as WinConnect:

http://www.thinsoftinc.com/products.aspx

If only 2 people ever need concurrent connectivity, you can use
the built in RDP in Windows.

Not with WinXP workstation, only with Windows Server, and only then
if you give the users administrative permission on the Windows
Server.

Basically, the built-in TS licenses are worthless except for people
you'd already give admin permission on the server, e.g., your
sysadmins and your Access developer, but certainly not your regular
users.

 

[Arvin Meyer [MVP]]

Not with WinXP workstation, only with Windows Server, and only then
if you give the users administrative permission on the Windows
Server.

Basically, the built-in TS licenses are worthless except for people
you'd already give admin permission on the server, e.g., your
sysadmins and your Access developer, but certainly not your regular
users.

WinConnect can be used with up to 21 concurrent users on a server or on XP
Pro. A Windows Server has 2 RDP licenses/connections. And an XP Pro
Workstation, has 1 RDP connection. Yes you need admin permissions without a
Terminal Services license with an RDP connection.