Is it possible to use MSAccess table on PDAs

[Ivan Sammut]

Hi,

I uploaded an Access Database on my pda but now I need to access it thru
my c# program. Can this be done? If yes could u pls give me an example or a
link from where I can get some info.

Thanks
Ivan Sammut

 

[Simon Hart]

No. You need a Pocket Access version of the database and you will need to
use P/Invokes in order to access it as there are no API's in CF which allow
you to do this.

Note I believe Pocket Access is no longer supported on WM5. I recommend to
use a proper RDBMS solution such as SQL Server CE edition.

Regards
Simon.

 

[Ivan Sammut]

Does SQl Server CE come for free. If yes from where can I download it

Thanks
Ivan

 

[Simon Hart]

Yes the EULA state that it is free unless you use the synchronization
features which enable you to sync with SQL Server on the desktop.

If comes with Visual Studio. Version 3 if using VS.NET 2005 or version 2.0
if using VS.NET 2003.

Regards
Simon.

 

[frank]

Please consider Visual CE from my company, SYWARE, Inc as
analternative.It allows you to use Access tables on the device, keeps
them sychronized and has a form builder similar to MS Access.

http://www.syware.com/products/visual_ce.php

My Best,
Frank Yacano