Using Access DB's with SQL-CE on a handheld

[Bill]

For a variety of user-driven reasons, we're using an
Access DB on a Desktop as the repository for data we
transfer to/from a Pocket PC 2002 Application that uses
SQL-CE. Have not yet located a provider, so for
transferring the data back and forth we're stuck with
using Sockets and techniques really provided for
messaging.

Anybody got/seen a better mousetrap?

[Yan-Hong Huang[MSFT]]

Hello Bill,

I am finding somebody who could help you on it. Thanks very much.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
!Content-Class: urn:content-classes:message
!From: "Bill" <by****@wrytesystems.com>
!Sender: "Bill" <by****@wrytesystems.com>
!Subject: Using Access DB's with SQL-CE on a handheld
!Date: Fri, 15 Aug 2003 08:18:42 -0700
!Lines: 11
!Message-ID: <0a****************************@phx.gbl>
!MIME-Version: 1.0
!Content-Type: text/plain;
! charset="iso-8859-1"
!Content-Transfer-Encoding: 7bit
!X-Newsreader: Microsoft CDO for Windows 2000
!Thread-Index: AcNjQILntpRJbn/jQ1GFHqSB5j+uJg==
!X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!Newsgroups: microsoft.public.dotnet.general
!Path: cpmsftngxa06.phx.gbl
!Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:104694
!NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
!X-Tomcat-NG: microsoft.public.dotnet.general
!
!For a variety of user-driven reasons, we're using an
!Access DB on a Desktop as the repository for data we
!transfer to/from a Pocket PC 2002 Application that uses
!SQL-CE. Have not yet located a provider, so for
!transferring the data back and forth we're stuck with
!using Sockets and techniques really provided for
!messaging.
!
!Anybody got/seen a better mousetrap?
!
!
!

[Vikrant V Dalwale [MS]]

Hello Bill,

Thanks for your patience.

Well, you cannot do replication against SQL Server CE from Access since we
do not support that.
MSDE might be an option here if you want to do a straight transfer from
CE. I’m not aware of any provider that will help move
data directly from SQL Server CE to Access db.

Does that help answer your question ?

Thanks for posting to MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.

--------------------

Content-Class: urn:content-classes:message
From: "Bill" <by****@wrytesystems.com>
Sender: "Bill" <by****@wrytesystems.com>
Subject: Using Access DB's with SQL-CE on a handheld
Date: Fri, 15 Aug 2003 08:18:42 -0700
Lines: 11
Message-ID: <0a****************************@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcNjQILntpRJbn/jQ1GFHqSB5j+uJg==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.dotnet.general
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:104694
NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
X-Tomcat-NG: microsoft.public.dotnet.general

For a variety of user-driven reasons, we're using an
Access DB on a Desktop as the repository for data we
transfer to/from a Pocket PC 2002 Application that uses
SQL-CE. Have not yet located a provider, so for
transferring the data back and forth we're stuck with
using Sockets and techniques really provided for
messaging.

Anybody got/seen a better mousetrap?