Pocket PC and Microsoft Access

Pocket PC and Microsoft Access

Post by Y29vbmVyN » Tue, 12 Aug 2008 02:49:00


I am a software developer/seller. My programs are compiled Visual Basic 5.0
(.exe) and uses Access 2000 as the database. A major customer has requested
to be able to download this on to a Pocket PC/ Handheld. I am a Major Rookie
with these devices (never owned or used one). I have researched about the
different devices (OS) i.e. Windows Mobile, Windows CE, etc. and seem to be
more confused (some say yes - some say no). Can anyone tell me the best (OS)
to use without a third party software and can this be done?
Thanks,
--
David
 
 
 

Pocket PC and Microsoft Access

Post by Chris Tack » Tue, 12 Aug 2008 04:29:28

Access database files cannot be directly consumed by a device application.
There are mecahnisms to get it into usable form, so require 3rd party tools,
some require things liek a SQL Server, some simply require a lot of code on
your part for a desktop import/export mechanism.

Your VB program will also not run on a mobile device, so it would likely
need to be fully rewritten or ported (at least the portions that make sense
for a mobile device).

In short, I'd be inclined to write just the poieces they need for the device
using a SQL CE backend database. I'd then buy or create a tool that could
move the desktop Access data to/from that SQL CE database.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://www.yqcomputer.com/

 
 
 

Pocket PC and Microsoft Access

Post by Y29vbmVyN » Tue, 12 Aug 2008 06:08:00

Thanks Chris. Now I am totally lost. Is there such a thing as wireless PC
anywhere that can be installed on a handheld? If the program was installed
on the users computer and the database was on a server? That is the way the
current programs work using ADO connection.
--
David
 
 
 

Pocket PC and Microsoft Access

Post by Chris Tack » Tue, 12 Aug 2008 07:33:34

What is "wireless PC"? you say it as if it's some form of OS to be
installed on a mobile device. If so, there is no such thing and for a
variety of reasons including processor architecture, available memory and
storage, power consumption, etc. etc.

If you need a fairly portable device running a desktop OS like XP or Vista,
look into a UMPC. If you need an actual handheld size device like a
standard PDA, then no there isn't such a thing. Physics and human
manufacturing capabilities havn't yet made it possible. If you need a PDA
sized device, you're going to have to write new software.

One possibility would be a VNC or RDP client on the PDA and a host PC that
they connect to. I've not been impressed with the performance of those
systems in the past though.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://www.yqcomputer.com/
 
 
 

Pocket PC and Microsoft Access

Post by Y29vbmVyN » Tue, 12 Aug 2008 08:43:00

hanks again Chris. I am just a "Old Programmer" that use to program the "
OLD IBM Mainframes". I am not up to date on today's technology. You were
very helpful - I looked up VNC, RDP and UMPC ( I had no idea). But from what
I am understanding I will need a host PC that they connect to. Once again,
please excuse my ignorance "wireless pc". What would you suggest to be the
best path to take?
--
David


"Chris Tacke, eMVP" wrote:

 
 
 

Pocket PC and Microsoft Access

Post by Chris Tack » Wed, 13 Aug 2008 00:34:55

can't suggest a best path, as I have no idea of the requirements, the
budget or the schedule. All I can do is give you the info to help you
decide what you consider to be the best path. If a UMPC will work for you,
it's probably the lest effort - just install your existing app on it and
you're done. If you need an actual PDA and you will have dedicated,
reliable network connectivity (and a RDP host running the software is
acceptable), I'd probably at least evaluate VNC/RDP to see if it works. If
that doesn't meet the requirements, then it's time to start writing new
code.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://community.OpenNETCF.com


"cooner5" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...