Here is a regurgitated post of mine to the same sort of question. If you
Google this newsgroup for the relevant terms, you may find some good info.
------------------------------------------------------------------------
With SQL Server, there is software that synchs your mobile device directly
with SQL Server, SQL Server CE at
http://www.microsoft.com/sql/CE/default.asp
However, with Access, your choices are less perfect. Pocket Access is
nothing more than the database storage, with no provided means to get to the
data - Pocket Jet might have been a better name.
You can easily export Access data into html format, which can then be
displayed in IE on the PDA. This is what I currently do, however, there is
no way to get data into the PDA using standard IE. I tried using xml, which
worked fine with Windows CE 2000, however, the newest version of Windows
Mobile, 2003, introduced a bug that does not allow XML to be displayed (at
all) using XSL.
Visual CE looks like a promising development langage for databases, but I've
not tried it:
http://www.syware.com/about/about.htm
Here is an article on using embedded Visual Basic with ADOCE, which is ADO
for Windows CE, but is not an MS product, and is not cheap.
http://www.devbuzz.com/content/zinc_...tabase_pg2.asp
There are lots of Windows CE databases springing up; I've looked at a lot of
them, but haven't decided on one yet. Here are some of the more highly
regarded:
http://www.biomobility.com/dotr4.htm http://www.handmark.com/products/detail.php?id=74 http://www.kaione.com/Product_Info/product_info.html
Also, Grandasoft has an interesting product.
Darryl Kerkeslager
"sea" <se*****@hotmail.com> wrote:
How do I convert an access database application for use with a PDA and
hand helds? Thank you very much.