Thanks for the suggestions. Is there some documentation on how to setup
1. user collects data
2. user connects laptop to internet
3. System sees an internet connection and start syncing between MSDE and SQL
"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:e1EeSP6jEHA.3664@TK2MSFTNGP11.phx.gbl...
> Sure, MSDE and SQL Server can replicate to each other (if that's what you
> mean). It works fine according to most reports.
> No, I would not store BLOBs (pictures) in the database--even SQL Server
> Standard that has a lot more capacity than MSDE (which is limited to 2
GB).
> Store the path to the picture file in the database.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
>
www.betav.com > Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Jake" <rondican@hotmail.com> wrote in message
> news:ubKUFJ5jEHA.2544@TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > We have an application that collects data into and access db. Then
the
> > user connects to the internet and the access db syncs with our sql using
a
> > vb.net application. We have some issues at times with this vb.net
> > application. I am wondering if we use msde on the client machine and
they
> > connect to the internet if there is a way to auto sync the data through
> > sql
> > thus removing the vb.net application. Is this possible could someone
give
> > me
> > the pros and cons? We are also hoping to add photos into msde if
possible.
> > Thanks in advance.
> >
> > Jake
> >
> >
>
>
