Pocket Access for Pocket PC

[Cris]

I would appreciate someone's help in knowing if Pocket
Access is able to be placed on Pocket PC 2002 edition
PDA's and if it would be any better than other 3rd party
software like HanDbase?

 

[Doug]

-----Original Message-----
I would appreciate someone's help in knowing if Pocket
Access is able to be placed on Pocket PC 2002 edition
PDA's and if it would be any better than other 3rd party
software like HanDbase?
.

You can put your Access databases on your PDA and
ActiveSync will convert it to a .cdb file. You can also
set up activesync to replicate the database every time
you sync with your pc. You will have to use emBedded
Visual Basic ot emBedded C++ to write an application to
use the tables inthe database. I have done one in VB and
it work fairly well.

Doug

 

[Tony Toews]

I would appreciate someone's help in knowing if Pocket
Access is able to be placed on Pocket PC 2002 edition
PDA's and if it would be any better than other 3rd party
software like HanDbase?

It's my understanding that Pocket Access was pretty weak when it came
to features. For the price I'd sure consider HanDbase.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Brendan Reynolds \(MVP\)]

Piggy-backing on Tony's post because I don't see the original post in my
newsreader ...

There seems to be considerable confusion about Pocket Access. I had always
understood that Pocket Access was a cut-down version of Access that was only
ever bundled with devices using one particular version of the Windows CE
operating system, and was not available in any other way or with any other
version of Windows CE. So I was quite surprised to find 'Pocket Access'
supported on my new Dell Axim Pocket PC 2002 device! But this 'Pocket
Access' is not an application, but a database engine - it really should have
been called 'Pocket Jet'. It has no UI, it is a component that is only
available via code.

ActiveSync can transfer files between the PC and the Pocket PC,
automatically converting from the desktop MDB format to the 'Pocket Access'
CDB format, but it's just a straight file transfer - the developer is
responsible for all the work of synchronising records. And there is no
support for 'Pocket Access' in .NET, the only way to use it with .NET is to
write unmanaged wrappers in eMbedded VC++, so it's probably not a good
choice if 'future-proofing' is an important consideration.

 

[Tony Toews]

There seems to be considerable confusion about Pocket Access. I had always
understood that Pocket Access was a cut-down version of Access that was only
ever bundled with devices using one particular version of the Windows CE
operating system, and was not available in any other way or with any other
version of Windows CE.

Likewise. Cut down though was not my impression. My impression is
that it was extremely primitive. As in worse than the database
component of Microsoft Works.

So I was quite surprised to find 'Pocket Access'
supported on my new Dell Axim Pocket PC 2002 device! But this 'Pocket
Access' is not an application, but a database engine - it really should have
been called 'Pocket Jet'. It has no UI, it is a component that is only
available via code.

This almost sounds like "SQL Server for Win CE" or whatever it's
called. It's my understanding that the Jet team created this once
they finished with Jet 4.0.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm