pocket access

  • Thread starter Thread starter Nathan Franklin
  • Start date Start date
N

Nathan Franklin

hey guys, i think i have decided upon using pocket access.

it is just for a simple app with simple sql queries ( nothing more then
inner joins )

my question is, how do i add the database into activesync so it sync with
every sync operation..

i need to know how to do it programatically, could someone please help me..

also am I likeley to run into any problems using pocket access, it is for a
relativly small app not exceed 65000 records...

its a slow db isnt it? thats ok i guess, but i dont think i need to go to
the trouble of installing sql server ce, and then msde on the desktop and
also configuiring iis for replication.. etc.. etc.. blah blah especially
when this all has to be automated!!

thanks heaps dudes

kind regards
nath
 
nath,

The biggest problem with Pocket Access is that it isn't available on Windows
Mobile 5.0. The second biggest problem is speed. Both SqlCE and SQL Mobile
are faster, and SQL Mobile is certainly the best choice if you are using CF
2.0. The biggest problem with the SQL products is that you can't use
Activesync to just sync them (although merge replication and RDA are options
for syncing with SQL Server), so you'll need a 3rd party product like one of
these:

www.gui-innovations.com
www.primeworks.pt
 
Hi,

Pocket Access does suck bigtime, avoid. I find SQLCE2.0 performance good on
CF1.0.

Is SQL Mobile the next version of SQLCE?

Regards
Simon.
 
Simon,

As Arun says, yes. It's been completely rewritten for performance and
features.
 
Back
Top