>>You can run MSDE on the laptop, and should be able to produce what you need. I have a question, though. How does the data "get" to the laptop? Do they have to download it whenever they want to "undock"? Or are you actually keeping copies in both places (currently)?
>
>What is MSDE and how will that help to get data from an SQL Server that is not present when they undock and have no communication link?
It's SQL Server Lite ;-)
http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp>
>How the data is done presently is that when they are docked they download a duplicate of the data from the server onto their PC. So what is happening is that they are running some system data from the server and some locally (duplicate of what is on the server), then when they undock and go on travel they have the data locally to query from, but the network systems will be disabled as they are not connected to get to them.
>
>>
Seems to me that you could do essentially the same thing you are doing now.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown