Re: Does Pocket PC 2003 or the latest vesion of CE support MS Access Data Access Pages

From: David C. Holley (DavidCHolley_at_netscape.net)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 07:38:12 -0500

So if I understand it correctly, your NEED is to add/edit records on a
PocketPC? If so you could try a third-party solution that provides
access to DB's on a Pocket PC. I would suggest going to
www.pocketGear.com you'll find plenty of programs available AND most of
them can be downloaded as trials.

I personally have been quite satisfied with DB Anywhere
(http://www.pocketgear.com/software_detail.asp?id=1190)

If you're looking for something with a bit more control you may want to
try ActiveServer Component which is DLL that can be purchased that will
allow you to run ASP pages on your PocketPC. Although you'll have to
write the ASP pages you should be able to use the same ASP pages on a
intranet so there's some added value to the time involvedd.

http://www.intorel.com/Products/ActiveServerComponent/overview.asp?pid=

David H

Neil Smith [MVP Digital Media] wrote:
> On 19 Dec 2004 08:08:30 -0800, rcmail14872@yahoo.com wrote:
>
>
>>Neil, it's a single table like an excel spread***, no related tables.
>>There are only about 5 pieces of information collected. I know XML
>>and XSL, and Access VB; I could learn some JavaScript or VBScript.
>
>
> OK, that's fine. I'm about 1/2 way to a solution. If you look in the
> export as XML options for Access, then it exports a single table (and
> any linked tables) at a time. I decided to see if it was possible to
> make a generic transformation which would load the .xsd (field
> definitions) and .xsl style***, and format the table results for
> on-screen use.
>
> It turns out that PPC won't load XML files unless they actually end in
> the extension .xml :-P So the XSD was out. Luckily, Access allows you
> in the export 'More Options', to Embed the Schema with the XML data,
> giving you a full picture of the dataset. Tick both those boxes (Data
> + Schema) and have a look at the 'More Options'.
>
> Probably all this could be achieved with a Macro, to allow your users
> simple updates to the view seen by the PPC.
>
> The second choice apart from client-side transforms, you can export
> the data and style*** as code for ASP (it's very basic but it seems
> to work). Is there any chance you have a machine which runs IIS ? I
> think even the basic version in Win2000 Pro / XP Pro can support up to
> 5 simultaneous users.
>
> So you'd then be down to modifying the existing style*** which
> Access exports when you choose export for ASP.
>
>
>>David, I'll describe the database situation, let me know if I have left
>>out any details that would help. The database consists of a MS Access
>>database with the "back-end" tables on a network (Windows) PC in a
>>shared folder (not a client-server setup). The "front-end" with the
>>Forms, Reports, etc. runs on a laptop that has a barcode scanner
>>connected to it. The scanner scans sheets of paper that have barcodes
>>on them with various information like Model Number, etc., after the
>
>
> Hey I'm doing this for out MIS application ;-)
> It's all PHP based though <g>
>
>
>>terminal like HHP Dolphin 7450, running Pocket PC 2002 and to connect
>
>
>>So I was trying to use Data Access Pages with PIE to add/edit records.
>>And Pocket PC 2002 doesn't support DAP, BUT, I think Pocket PC 2003
>>might. If it does, that might be a simple solution.
>
>
> ** For what I'm talking about (XML data) you will *definitely* need WM
> 2003 BTW. I've got an Axim X3 here, and it doesn't support DAP.
>
>
>>What do you think? There is no vital reason to connect real-time. We
>>could lug a laptop around the warehouse with a blue-tooth scanner and
>>get about 30 feet from the scanner, or just collect the data and update
>>after. My clients would really, really, like to collect the data
>>real-time, without purchasing any expensive software, and I would like
>>to offer this to them but, is this impractical, unrealistic?
>
>