Question about msde

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
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
>
|||Bill,
Thanks for the suggestions. Is there some documentation on how to setup
an MSDE to sync with SQL2k when a laptop is connected to the internet? I
would like this automatic if possible.
For example:
1. user collects data
2. user connects laptop to internet
3. System sees an internet connection and start syncing between MSDE and SQL
server.
Thanks in advance.
Jake
"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.[vbcol=seagreen]
> __________________________________
> "Jake" <rondican@.hotmail.com> wrote in message
> news:ubKUFJ5jEHA.2544@.TK2MSFTNGP10.phx.gbl...
the[vbcol=seagreen]
a[vbcol=seagreen]
they[vbcol=seagreen]
give[vbcol=seagreen]
possible.
>