Discussion Locked

Access database syncronization

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a client who is fairly computer illiterate. He has a Windows 2000 Server, two Windows 98 desktop machines and a laptop running Windows XP Pro. He wants to be able to take his work home with him on his laptop. He uses the desktop machines in the office, and uses his laptop in the field or at home. I set up Offline Files to syncronize every time he brings his laptop into the office and plugs it into his docking station. I found out that Windows' Offline Files doesn't syncronize Access databases. I was wondering if anyone could recommend a program to syncronize all files, including the Access databases. It needs to be simple enough that when he docks his laptop and logs on, it automatically syncronizes his files with the server. It also need to do the same when he logs off. Any suggestions?

3 replies

by lmayeda

A possible option would be for the laptop user to activate terminal services, connect to the Windows 2000 server as a TS client when he is in the field. Then when he connects to the server, he can work directly with the database w/o having to syncronize. Our server connects to the internet via DSL and our users either connect to the internet via dialup or cable.

by advancedcomputers

What I mean by "in the field" is either in his truck or at one of his client's houses, away from an internet connection.

by sulls

For our remote laptop users, we have written a program which checks whether they are connected to the server when they start the program up each time. If they are connected, it copies the back end data locally and then uses the online back end whilst connected. Once they leave the office, it recognises that they are away and relinks them to the local c drive back end.
Any more help or info, please let me know.

This discussion is closed to new replies.