"L Mehl" <mehl_nospam@cyvest.com> wrote in message
news:uKBge.6541$Dh.3296@newsread2.news.pas.earthlink.net...
> Hello --
>
> If this question is more appropriate for another newsgroup, please tell
> me.
>
> Our application requires the following:
>
> - users planning travel or being at location without access to the server
> (SQLServer 2000) want to be able to review and/or process selected records
> on their local machine (assume local machine will use MSDE as the
> platform),
> then upload these records when they can once again connect to the server
>
> - system will allow user to download/"check-out" one or more parent
> records
> and their related child records from SQL Server 2000
>
> - lookup tables will also be downloaded when data records are downloaded
>
> - such downloading will either delete the data records on SQLServer or
> mark
> them "checked-out" so they will (a) not be available other users or (b) be
> displayed to other users as "checked out by ..."
>
> - user can upload/"check-in" all downloaded records when access to server
> is
> regained
>
> I will appreciate advice as to where to start looking for discussion or
> examples of how to do what we want to do.
>
> Is there a generic term for such a process?  Is MSDE the platform to use
> on
> the local machine?
>
> Thanks in advance for any help.
>
> Larry Mehl
>
>
>
>

"Michael C#" <ho***@boutdat.com> wrote in message
news:ON#XRfzVFHA.3716@TK2MSFTNGP12.phx.gbl...
> You might start by looking into Merge Replication.  Check out this
article:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;324992
>
>
> "L Mehl" <mehl_nospam@cyvest.com> wrote in message
> news:uKBge.6541$Dh.3296@newsread2.news.pas.earthlink.net...
> > Hello --
> >
> > If this question is more appropriate for another newsgroup, please tell
> > me.
> >
> > Our application requires the following:
> >
> > - users planning travel or being at location without access to the
server
> > (SQLServer 2000) want to be able to review and/or process selected
records
> > on their local machine (assume local machine will use MSDE as the
> > platform),
> > then upload these records when they can once again connect to the server
> >
> > - system will allow user to download/"check-out" one or more parent
> > records
> > and their related child records from SQL Server 2000
> >
> > - lookup tables will also be downloaded when data records are downloaded
> >
> > - such downloading will either delete the data records on SQLServer or
> > mark
> > them "checked-out" so they will (a) not be available other users or (b)
be
> > displayed to other users as "checked out by ..."
> >
> > - user can upload/"check-in" all downloaded records when access to
server
> > is
> > regained
> >
> > I will appreciate advice as to where to start looking for discussion or
> > examples of how to do what we want to do.
> >
> > Is there a generic term for such a process?  Is MSDE the platform to use
> > on
> > the local machine?
> >
> > Thanks in advance for any help.
> >
> > Larry Mehl
> >
> >
> >
> >
>
>