Pocket pc database example

I am currently working on a pocket pc application for a pocket pc on the pocket pc is a windows os.

I have a small Microsoft access database from witch i need some data in my application.

Does anyone have an example of how to connect to and access database on a pocket pc and how to retrieve data with SQL statements?

I am stuck with this problem for a couple of days now so every help is more then welcome.

Thank in advance,
Joost Horstman

P.S. sorry for my bad english i am dutch so english isn't my main language.

I've used Sql Server CE, but not Access, sorry I can't help much. Maybe this article will help.

Well i can work with SQL databases as wel so if you got an example of that i really apriciate it.

You using Pocket PC 2003 and Visual Studio 2003? If so, life will be good. The compact framework is lacking an easy way to work with Pocket Access. Seems like the push is towards Sql Server CE.

This I thought was a pretty good article, although it does focus on replication. If you go to MSDN Magazine and search for "sql server ce", you'll find lots of examples.

Mike

thx for the info i appreciate it!!!