Access (mdb) on Pocket PC?

[Guest]

Hi,

I created a mdb database with a desktop program and I want to open and edit
the entries on a pocket pc. Is this possible? How can I do this? Thank
you....juvi

 

[Sergey Bogdanov]

Try this:
http://www.inthehand.com/ADOCE.aspx

 

[Guest]

Thank you for your quick reply. Is this the only way? What would you suggest
me to do --> I want to do the following thing:

- Create a database from a treeview with a desktop program written in vb.net
- The database should be compatible with the pocket pc, so that I can
retrieve and
edit data to fill the treeview in the compact framework program
- At the end I want to open the database again on the desktop program

thank you. juvi

Try this:
http://www.inthehand.com/ADOCE.aspx


--
Sergey Bogdanov [.NET CF MVP, MCSD]
http://www.sergeybogdanov.com

Hi,

I created a mdb database with a desktop program and I want to open and edit
the entries on a pocket pc. Is this possible? How can I do this? Thank
you....juvi

 

[Simon Hart]

Pocket Access is very slow and from memory not supported under Windows
Mobile 2005 and onwards. You could use SQL Server CE 3/2005, then use
inbuilt sync functions such as RDA to sync with your desktop SQL Server
database.

Cheers
Simon.

Thank you for your quick reply. Is this the only way? What would you
suggest
me to do --> I want to do the following thing:

- Create a database from a treeview with a desktop program written in
vb.net
- The database should be compatible with the pocket pc, so that I can
retrieve and
edit data to fill the treeview in the compact framework program
- At the end I want to open the database again on the desktop program

thank you. juvi

Try this:
http://www.inthehand.com/ADOCE.aspx


--
Sergey Bogdanov [.NET CF MVP, MCSD]
http://www.sergeybogdanov.com

Hi,

I created a mdb database with a desktop program and I want to open and
edit
the entries on a pocket pc. Is this possible? How can I do this? Thank
you....juvi

 

[John T]

Thank you for your quick reply. Is this the only way? What would you
suggest me to do --> I want to do the following thing:

- Create a database from a treeview with a desktop program written in
vb.net
- The database should be compatible with the pocket pc, so that I can
retrieve and
edit data to fill the treeview in the compact framework program
- At the end I want to open the database again on the desktop program

Pocket Access is a decent option if you're using PocketPC 2003 or earlier.
Pocket Access is not supported on Windows Mobile 5.

Further, Peter Foot's ADOCE component from www.InTheHand.com is very good
for wrapping the CEDB API calls for use in .Net (I've used it myself), but
will not provide you any GUI to create/manage databases. That's up to you
to build.

As for syncing, you can configure ActiveSync to synchronize a Pocket Access
database with an Access database on the desktop, but this is restricted to
Access only.

There are other options for keeping data in sync between the device and
desktop. Three contenders are SQL Mobile (SQLCE), db4o, and SQLite. See my
previous post for more info (beware of line-wrap):
<http://groups.google.com/group/micr..._frm/thread/f1f7fd5a0151b6bd/583e643390e761a0>

There are other database options, as well, including a text-based one
provided by www.OpenNETCF.org.

--
John T
http://tknowlogy.com/TknoFlyer
http://www.pocketgear.com/products_search.asp?developerid=4415
Reduce spam. Use Sender Policy Framework: http://spf.pobox.com
____________________