Mobility and MS Access

[RPhenicie]

How can a simple MS Access database be used with MS
Pocket PC on a PDA?
Can the MS Access database be used with other PDAs?
How could MS Excel be used in place of MS Access on the
PDA?
What 3rd part database tools available for PDAs?

 

[M.L. Sco Scofield]

All of the groups that start with microsoft.public.access are for the full
version of Access. You might have better luck in one of the 10 Pocket PC
groups that all start with microsoft.public.pocketpc.

You might also try searching the internet. There are several mini-databases
that run on handheld devices. Synchronizing them with a full database like
Access will be a function of the handheld device's program.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Jim Carlock]

I don't know much about it, but if the MDB file can be placed
onto a PDA, then you can write the code to copy the file back
and forth between the PDA and whatever it docks to.

And if the file can be placed on a PDA, the code can be written
in at least C/C++ to create a PDA form that ... well, I'm not
sure how this will work, because you'd need to have some kind
of data access protocols set up (these are the MDAC DLL files
on a normal computer system). I'm just not familiar with writing
for a PDA, but I imagine that PDA are coming with at least a
GB of Firmware that can act as a hard drive and operating
memory.

Perhaps you could relay some information back about anything
that you know for a fact about coding for a PDA?

The other thing to look for is some kind of ODBC on the PDA,
because if that's there, then you can connect to the MDB via
ODBC rather than transfering the file back and forth.

If the PDA connects and appears as a drive letter on a docking
station, you can set up ODBC on the docking station to
connect to the PDA when it's docked.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


How can a simple MS Access database be used with MS
Pocket PC on a PDA?
Can the MS Access database be used with other PDAs?
How could MS Excel be used in place of MS Access on the
PDA?
What 3rd part database tools available for PDAs?

 

[Arvin Meyer]

How can a simple MS Access database be used with MS
Pocket PC on a PDA?
Can the MS Access database be used with other PDAs?
How could MS Excel be used in place of MS Access on the
PDA?
What 3rd part database tools available for PDAs?

I use a 3rd party database HanDBase:

http://www.ddhsoftware.com/handbase.html

which sync's with Access and can be used to enter and edit data. It works
with either PocketPC or Palm.

Pocket Excel sync's with Excel and can be used to import/export data with
Access There are lots of tools available, try one of the PocketPC newsgroups
for the names of some of them.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access