Pocket Access

[draymorris]

I cannot even find pocket Access on my Dell Axim. How do I get it on the Pocket PC - it shows in Activesync.

 

[Albert D. Kallal]

It really should be called pocket JET sync.

I am sure you are aware that Sql server is just a database system. Sql
server does not come with any ability to create reports, forms and ANY PART
of the user interface. Yet, often people come to this newsgroup and ask
should they use sql-server in place of ms-access. Well, you can't replace
ms-access with sql server, since sql-server has no ability to create forms,
reports etc. It is ONLY a data engine.

The same goes for the Oracle database. It is a database, but the you must
choose some OTHER TOOLS to create the interface to that database.

So, really, pocket access is really only a conduit that lets you move data
back and forth, and HAS NOTHING to do with building forms,a and a interface,
On the other hand, sql serer also has nothing to do with building the
interface either. So, one should not be too surprised that a database engine
does not come with the ability to crate forms, reports etc, as this is the
standard way things work in the IT industry.

Having said all of the above, it should be called a JET conduit.

There is no such thing as a version of ms-access for the pocket pc. However,
there is a ton of applications you can get for the PPC that allows you to
exchange data with ms-access

Generally, this means a VB like development approach to building your
interface.

Another great wayto get lists and data to the PPC is simply to use Excel.

Pocket PC Access Database Alternatives
http://www.oreillynet.com/pub/wlg/3358

The "Missing" Pocket PC apps: Access & PowerPoint
http://www.oreillynet.com/pub/wlg/3300

 

[Brendan Reynolds \(MVP\)]

Just to add a little to Albert's reply, there is no user interface for
'Pocket Access', it's not something that a user manipulates directly. It's
used behind the scenes by programs, just as Access and other applications
use JET behind the scenes on the PC. It is, as Albert says, unfortunately
very misleadingly named.

--
Brendan Reynolds (MVP)
(e-mail address removed)

I cannot even find pocket Access on my Dell Axim. How do I get it on the

Pocket PC - it shows in Activesync.

 

[Dave]

Then how do you 'use' it?

if i wanted a cut down Access db to be used on a Pocket PC for a replicated
Db
what do i use to design the interface for the Pocket PC?

Sorry if this has alredy ben answered in the original post but my news
server cant find the original post (says it has been removed)

 

[Arvin Meyer]

I use a product called HanDBase to sync my data with Access on my Dell Axim
PPC. It works well. I use the Pro version which allows me to create forms.
One thing you'll need to get used to is that Access is far more
sophisticated than any other system. For instance, Access is the only
interface that allows subforms.

With databases like HanDBase, you need to use Access to build a Make-Table
or Append query with the relational data being made flat, then sync that
data with the PPC. You can sync both ways. Once the data is back in the
Access table, you need to run queries to parse it out and make it relational
again.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D. Kallal]

You can use any of the embedded tools that ms makes for the PPC.

That would include eVB, eC++, and I suppose the new eVB.net.

The "e" stands for embedded.

Just like you can write code in VB, or c++ that will read a JET mdb file, we
are talking about the same thing here.

If you are not comfortable writing applications in VB, then I don't think
you will like eVB. The process of using a JET database is really identical
in both cases.

I gave a number of links to some PPC database programs that also have form
creating ability.

However, if you are comfortable with VB, building forms in VB, and
connecting those forms to a database, then you can use the exact same
process for the PPC.

I would probably use a product that has bound database forms like ms-access
does, and thus you want to use a RAD tool.

However, if you want to build software the traditional way, then you can
check out the e Development tools at:

http://www.microsoft.com/windowsmobile/resources/downloads/developer/default
..mspx

 

[Dave]

Albert

Thanks, thats a great help.

Dave

 

[Brendan Reynolds \(MVP\)]

There's not much to add to what Albert has said, except that .NET does not
have any built-in support for 'Pocket Access', or for the ADOCE data object
library that is used to access data in 'Pocket Access' .CDB files, although
I understand there is a third party component that adds ADOCE support to
..NET.

Yep, here it is ...
http://www.devbuzz.com/content/zinc_dotnet_pocket_access_pg1.asp

It's free, and the source code is provided.