PDA Database in Visual Studio

Not strictly web but I think we can post this stuff here

[bateman_ap]

Hiya, just wondered if in the collective genius of these forums someone can put me in the right track! On my web site it is completly database driven and written in asp.

What I want to do next is write a PDA version in Visual Studio using Smart Device Application that can be used offline.

The problem I am finding is transferring the database so I can program with it. It is currently an access 2000 database. I would want to take this and what I want to do is embed the database in the application that i can
use without the end user installing any extra software. I can't find any documentation to do this though, can anyone point me in the right direction?

[Grumpus]

I haven't spent hours thinking about this - just enough time to hit the "reply button" and post. Therefore, there may be different ways - no, there ARE probably different (better) ways.

Here are my preliminary thoughts.

Export your database into a CSV or other delimited text database and then import that into a resource file. Then when the database changes, they simply need to interface with the lastest resource file that you place for them to download.

<shrug> Not bad for 30 seconds thought. I really know nothing about the operations of a PDA though.

[Xoc]

I'll give you two alternatives: One is to use XML, the other is to use SQL Server for Windows CE.