Is there any Microsoft applications (Excel, FoxPro, Access, etc..) that can
read SDF files directly?

I'm attempting to do replication of a database.  I successfully create a
blank database on the handheld using the sqlcereplication:
dbrep.addsubscription(addoption.createdatabase) - This creates a database
with no tables

I have an SQL table with a ntext column. That column contains data with 256
characters and more. I have also a pocket pc with SQL CE 2.0 with the same
table/column and an ntext datatype. Everytime I sync and the data (SQL
server) in the column has 255 charaters and less the sync ...

We are experiencing Replication problems to SQL CE.
Summary of Problem:
We are able to sync with many of our technicians that have similar
data with

I'm fairly new to the SQL Replication end of things, so I have an easy
question:
I'd like to designate one table on the SQL CE database that is write-only. I
don't need any records from the publishing database, I only need to add new

I am trying to do the following:
1) In my eVB code I open a database using ADOCE 3.0. I noticed that the
oClientConnection object (which is a ADOCE Connection obj) does not return a
handle but a string.

Sorry to keep blasting this board....
Is there a way to create derived queries in CE?
SELECT *
FROM tbl_Employees

I have a db with multiple tables, some of which can't be changed in the pda.  
But these tables have primary keys that are referenced from tables which can
change at the pda.
When I create a publication that doesn't have these tables, I get the

I'm new to mobile development and would like to apologize if my questions
sounds too newbie. Currently I'm developing embedded distributed system
running on Celeron 800 MHz with 512MB of RAM. Due to the fact that I have a
huge records (>100,000), I'm thinking of switching to SQL ...

I'm trying to change the length of a column called "Grade" in SQL CE from a
nchar(1) to 6 long
I've tried:
Alter Table HHLogSaleGrid

Is Windows CE the correct choice for developing an
application which will be used on a laptop type of device
while disconnected from the main database (SQL Server
2000 Ent. Ed.) but when connection is available will

I've decided to use RDA over CE Synchronization for the following reasons,
and I'd like some opinions about it to help me make sure I'm making the best
decision.
I have a database with with over 40 tables. I'd like to port ~20 of them to

System:
Server 2003 Standard (Stand alone mode)
IIS 6 configured running w/ Sharepoint Services
SQL 2000 Standard (sp3)

With push and pull functions in a vb application I obtain a replication error
28035 only when the pocket pc is connected with active sync to a particular
computer. With all other computers it works. Can anybody clarify the meaning
of "header missing or corrupted" which is the ...

       I cannot find the "LIMIT startRow, EndRow" syntax to limit the
resultset, how can I do so because I do not want to load all records from
the database at the first time.
Edward Chan