Does Pocket PC 2003 or the latest vesion of CE support MS ..

Archived from groups: microsoft.public.pocketpc (More info?)

Sorry for my ignorance. What is a "Data Acces Page"? Is this something you
created using something like FrontPage or Dreamweaver?
--
Todd Ogasawara, MS-MVP/Mobile Devices
Online Editor - http://MobileViews.com/ -- PDA & Wireless Info
http://www.OgasaWalrus.com/MobileDot/ - Brief News & Comments

<rcmail14872@yahoo.com> wrote in message
news:1103227766.016488.197630@f14g2000cwb.googlegroups.com...
>I created a simple Data Access Page and it views fine in Internet
> Explorer 5.5 on my PC. But when I try to view it on my Pocket PC
> running Pocket PC 2002 operating system, I get the error message that
> the page needs Internet Explorer 5.5 or higher to display. Does anyone
> know if the version of Internet Explorer that comes with Pocket PC 2003
> or the latest version of Windows CE supports Data Access Pages?
>

Archived from groups: microsoft.public.pocketpc (More info?)

If I understand it correctly, a Data Access Page is a HTML page that
allows you to add, change, delete data in an Access database. You could
think of it as a means to access the data via a thin client solution. As
to the original post, I'm not that familar with IE for PocketPC's,
however I suspect that as with Pocket Word and Pocket Excel that it (IE)
is trimmed down. When I loaded a page with some JavaScript code, the
code didn't work which leads me to believe that there are certain
features that are not available with the version of IE for Pocket PCs.

David H

Todd Ogasawara, MVP Mobile Devices wrote:

> Sorry for my ignorance. What is a "Data Acces Page"? Is this something you
> created using something like FrontPage or Dreamweaver?

[Original Message]
I created a simple Data Access Page and it views fine in Internet
> Explorer 5.5 on my PC. But when I try to view it on my Pocket PC
> running Pocket PC 2002 operating system, I get the error message that
> the page needs Internet Explorer 5.5 or higher to display. Does anyone
> know if the version of Internet Explorer that comes with Pocket PC 2003
> or the latest version of Windows CE supports Data Access Pages?

Archived from groups: microsoft.public.pocketpc (More info?)

I just tried Netfront and it gives the same error message as Firefox.
Maybe Microsoft fixed this in the latest version of PIE? What's this
PIE hack? Where can I get it? I'm willing to try anything at this
point.

Archived from groups: microsoft.public.pocketpc (More info?)

How did you create it ? On a web server ? In access ?

If you're using ASP.NET then the framework will adjust for rendering
on the mobile device. Is this what you meant ? Else you'll have to
provide more details of what you're doing ;-)

Cheers - Neil


On 16 Dec 2004 12:09:26 -0800, rcmail14872@yahoo.com wrote:

>I created a simple Data Access Page and it views fine in Internet
>Explorer 5.5 on my PC. But when I try to view it on my Pocket PC
>running Pocket PC 2002 operating system, I get the error message that
>the page needs Internet Explorer 5.5 or higher to display. Does anyone
>know if the version of Internet Explorer that comes with Pocket PC 2003
>or the latest version of Windows CE supports Data Access Pages?

Archived from groups: microsoft.public.pocketpc (More info?)

You might be interested in the product at this url

http://www.intorel.com/Products/Ac [...] w.asp?pid=

I haven't used it personally, but it sounds as if it provides the
capability to execute ASP pages on a pocket PC.

Neil Smith [MVP Digital Media] wrote:
> There are certain aspects of PIE which aren't supported. When you
> mention DHTMLm normally this is used to perform changes to the page
> without relying on page reloads from the server.
>
> In the case of PIE, you cannot change the page content once it's been
> created, without reloading the page. So this may be where it's falling
> down. Also "Data binding" is specfically listed as not supported, and
> data binding will often be used to talk back to the access database on
> the fly.
>
> The specific feature set included (which is HTML3.2) is listed here :
> http://msdn.microsoft.com/library/ [...] plorer.asp
>
> However there may be workarounds, using other technologies. You might
> also want to see if Access supports downlevel clients in the help
> documentation, there could be other acceptable ways of acquiring your
> data.
>
> If you could post your HTML it would be possible straight away to
> determine if it will work or could be modified to work.
>
> Cheers - Neil
>
> On 16 Dec 2004 20:25:21 -0800, rcmail14872@yahoo.com wrote:
>
>
>>I just found the blurb below on the Microsoft Mobile website. It
>>doesn't say anything about DHTML, which is what MS Access Data Access
>>Pages are made of, so maybe DAP still doesn't work in the latest
>>version? But then again maybe DHTML is included in the "and so on"
>>part of their blurb. Anyone know for sure? Anyone have MS Access
>>and Pocket PC
>>2003 that they can test this on?
>>---------------------------
>>"What's New for Developers in Windows Mobile 2003-based Pocket PC.
>>Updated Browser-Pocket Internet Explorer has now grown into an
>>honorable member of the Internet browser community with support for
>>HTML 4.01, CSS, XHTML, WML 2.0 and so on."
>
>

Archived from groups: microsoft.public.pocketpc (More info?)

Thanks, I tried it myself yesterday and I can see several areas which
will lock you out on PPC : They are listed below.

So I'm afraid you'll never get this working on a PPC, using *any*
browser, though it's perfectly possible to get data access controls
working on PPC, and it doesn't require this shoddy MS-IE-Office-only
coding to do it.

Let's think again :

You have a PC with an access database on it. And one or more Pocket
PCs, and that's connected to the PC how ?

Let's work from there.

Are you in a position where you can export the access database
regularly, lets say Save-As as XML data, and publish it on a
private/internal web server, or on an accessible network path (eg
\\mymachine\shared\database\daptest.xml) ?

Cheers - Neil


========================================
Local file path reference "Source=C:\daptest.mdb"


Unsupported Active X control (Office data source)
<OBJECT id=MSODSC classid=CLSID:0002E553-0000-0000-C000-000000000046>


Explicit non-IE5 or later lockout script :
function validateBrowser() {
// ..... etc
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32"
&& intVer>="5" ) {
validateOWC();
}


Implicit requirement for Active X controls :
function validateOWC() {
if (MSODSC.object==null) {
// ..... etc
}


Explicit (conditional comments) requirement for MS Office (v9) web
controls to be installed on the PPC (or pocket PCm, which you can't
do)

<!--[if gte mso 9]>
<xml>
<!-- Other data -->
</xml>
<![endif]-->

And the icing on the cake, even the images requre Office to be
installed (it's an internal "office" pathname) :

<img src="owc://GIF/#11220 />

========================================



On 17 Dec 2004 15:44:40 -0800, rickcheney@gmail.com wrote:

>Here's the HTML code, (actually it's supposed to be DHTML, Dynamic
>HTML). Sorry, it's a lot of code but the page is a very simple page.
>----------------------------------------------------------
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns =
>"urn:schemas-microsoft-comfficeffice" xmlns:a =
>"urn:schemas-microsoft-comffice:access" xmlns:x =
>"urn:schemas-microsoft-comffice:excel" xmlnst =
>"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>WarehouseTable</TITLE>
><META content="HTML 4.0" name=vs_targetSchema><LINK
>href="DAPWarehouseFormTEST_files/filelist.xml" type=text/xml
>rel=File-List>
><META content=Access.Application name=ProgId>
><META name=VBSForEventHandlers value="true">
><META http-equiv=Content-Type content=text/html;charset=UTF-8>
><META content=10.00.2225 name=DesignerVersion>
><OBJECT id=MSODSC tabIndex=-1
>classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM
>NAME="XMLData" VALUE='<xml
>xmlns:a="urn:schemas-microsoft-comffice:access">
><aataSourceControl> <aWCVersion>10.0.0.2621
></aWCVersion> <a:MaxRecords>0</a:MaxRecords>
><a:GridX>24</a:GridX> <a:GridY>24</a:GridY>
><afflineType>2</afflineType>
><a:XMLLocation>0</a:XMLLocation>
><a:XMLDataTarget></a:XMLDataTarget>
><a:ConnectionFile></a:ConnectionFile> <aatamodel
>a:version="0816"> </aatamodel>
></aataSourceControl> </xml>'>
>PARAM NAME="XMLData" VALUE="<xml
>xmlns:a="urn:schemas-microsoft-com:office:access">
><aataSourceControl> <a:OWCVersion>10.0.0.2621
></a:OWCVersion>
><a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
>
>Source=C:\daptest.mdb;Mode=Share Deny None;Extended
>Properties=&quot;&quot;;Persist Security Info=False;Jet
>OLEDB:System
>database=&quot;&quot;;Jet OLEDB:Registry
>Path=&quot;&quot;;Jet
>OLEDBatabase Password=&quot;&quot;;Jet OLEDB:Engine
>Type=0;Jet
>OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
>OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
>Password=&quot;&quot;;Jet OLEDB:Create System
>Database=False;Jet
>OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on
>Compact=False;Jet
>OLEDB:Compact Without Replica Repair=False;Jet
>OLEDB:SFP=False</a:ConnectionString>
><a:MaxRecords>10000</a:MaxRecords>
><a:GridX>24</a:GridX>
><a:GridY>24</a:GridY>
><a:OfflineType>2</a:OfflineType>
><a:XMLLocation>0</a:XMLLocation>
><a:XMLDataTarget></a:XMLDataTarget>
><a:ConnectionFile></a:ConnectionFile>
><a:ElementExtension>
><a:ElementID>ID</a:ElementID>
><a:ControlSource>ID</a:ControlSource>
><a:ChildLabel>ID_Label</a:ChildLabel>
></a:ElementExtension>
><a:ElementExtension>
><a:ElementID>SerialNumber</a:ElementID>
><a:ControlSource>SerialNumber</a:ControlSource>
><a:ChildLabel>SerialNumber_Label</a:ChildLabel>
></a:ElementExtension> <a:ElementExtension>
><a:ElementID>WarehouseTableNavLabel</a:ElementID>
><a:RecordsetLabel>WarehouseTable |0 of |2;WarehouseTable |0-|1 of
>|2</a:RecordsetLabel> </a:ElementExtension>
><a:GroupLevel>
><a:RecordSource>WarehouseTable</a:RecordSource>
><aefaultSort></a:DefaultSort>
><a:HeaderElementId>HeaderWarehouseTable</a:HeaderElementId>
>
><a:FooterElementId></a:FooterElementId>
><a:CaptionElementId>CaptionWarehouseTable</a:CaptionElementId>
>
><a:RecordNavigationElementId>NavigationWarehouseTable</a:RecordNavigationElementId>
>
><a:DataPageSize>1</a:DataPageSize>
><a:GroupFilterControl></a:GroupFilterControl>
><a:RecordSelector/> </a:GroupLevel> <a:Datamodel
>a:version="0816"> <a:SchemaRowsource
>a:id="WarehouseTable" a:type="dscTable">
>
><a:SchemaField a:id="ID" a:datatype="3"
>a:size="0"
>a:iskey="1"/> <a:SchemaField
>a:id="SerialNumber" a:datatype="130"
>a:size="50"/> <a:SchemaField
>a:id="Model"
>a:datatype="130" a:size="50"/>
><a:SchemaField
>a:id="CosmeticCondition" a:datatype="130"
>a:size="50"/> <a:SchemaField
>a:id="Make"
>a:datatype="130" a:size="50"/>
><a:SchemaField
>a:id="Ports" a:datatype="130"
>a:size="50"/> </a:SchemaRowsource>
><a:RecordsetDef a:id="WarehouseTable">
><aageField
>a:id="ID"/> <aageField
>a:id="SerialNumber"/> </a:RecordsetDef>
>
></a:Datamodel>
></a:DataSourceControl> </xml>"></OBJECT>
><STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
>BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
>3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in;
>BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN:
>left
>}
>.MsoTextbox {
>PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW:
>hidden; WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
>}
>.MsoBoundSpan {
>BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
>3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM:
>0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
>}
>.MsoHyperlinkDisplayText {
>BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
>3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand;
>BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
>}
>.Mso2dSection {
>LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden;
>POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
>}
>.Mso2dSectionBanner {
>PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT:
>normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR:
>url(#DEFAULT#Mso2dSectionBanner); PADDING-TOP: 2px; FONT-FAMILY:
>Tahoma; TOP: 0px; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface
>}
>.MsoRectangle {
>BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW:
>hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
>}
>.MsoTitle {
>DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
>}
>.MsoExpandCollapse {
>CURSOR: hand
>}
>.MsoNavContainer {
>BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
>Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand;
>BORDER-BOTTOM: gainsboro 1px solid; POSITION: absolute; HEIGHT: 25px;
>BACKGROUND-COLOR: gainsboro
>}
>.MsoNavButton {
>BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
>BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM:
>gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
>}
>.MsoNavButtonMouseOver {
>BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid;
>BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid;
>BACKGROUND-COLOR: buttonhighlight
>}
>.MsoNavToggleButtonMouseOver {
>BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid;
>BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid;
>BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonhighlight
>}
>.MsoNavButtonMouseDown {
>BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
>solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand;
>BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
>}
>.MsoNavRecordsetLabel {
>BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
>PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT:
>gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px;
>BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma
>}
>.MsoRecordSelector {
>BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
>solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; WIDTH:
>0.17in; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%;
>BACKGROUND-COLOR: gainsboro
>}
>.MsoRecordSelectorCurrent {
>BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11240);
>BACKGROUND-REPEAT: no-repeat
>}
>.MsoRecordSelectorSelectedImage {
>BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11241);
>BACKGROUND-REPEAT: no-repeat
>}
>.MsoRecordSelectorSelected {
>BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
>solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px
>solid; WIDTH: 0.17in; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px;
>HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow; POSTION: relative
>}
>.MsoRecordSelectorDirty {
>BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE:
>url(owc://GIF/#11242); BACKGROUND-REPEAT: no-repeat
>}
>.MsoRecordSelectorTransparent {
>LEFT: 0px; OVERFLOW: hidden; WIDTH: 0.17in; TOP: 0px; POSTION:
>relative
>}
>HR {
>COLOR: black
>}
>SELECT {
>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>}
>INPUT {
>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>}
>BODY {
>FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
>}
>MARQUEE {
>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>}
>LEGEND {
>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>}
>BUTTON {
>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>}
>TEXTAREA {
>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>}
>.Style0 {
>BORDER-RIGHT: transparent 2px inset; BORDER-TOP: transparent 2px
>inset; FONT-WEIGHT: 400; FONT-SIZE: 8pt; VISIBILITY: visible;
>BORDER-LEFT: transparent 2px inset; COLOR: #000000; BORDER-BOTTOM:
>transparent 2px inset; FONT-STYLE: normal; FONT-FAMILY: MS Sans Serif;
>WRITING-MODE: lr-tb; BACKGROUND-COLOR: #ffffff
>}
>.Style1 {
>BORDER-RIGHT: #000000 1px; BORDER-TOP: #000000 1px; FONT-WEIGHT: 400;
>FONT-SIZE: 8pt; VISIBILITY: visible; BORDER-LEFT: #000000 1px; COLOR:
>#000000; BORDER-BOTTOM: #000000 1px; FONT-STYLE: normal; FONT-FAMILY:
>MS Sans Serif; WRITING-MODE: lr-tb; BACKGROUND-COLOR: transparent
>}
></STYLE>
>
><META content="MSHTML 6.00.2600.0" name=GENERATOR>
><SCRIPT language=Javascript id=MSODSC_Validation>
>validateBrowser();
>
>function validateBrowser() {
>strVers=navigator.appVersion
>strName=navigator.appName
>strPlat=navigator.platform
>intIndex1=strVers.indexOf("MSIE" );
>intIndex1=intIndex1+5
>intIndex2=strVers.lastIndexOf(";" );
>intVer=strVers.substring(intIndex1, intIndex2)
>intVer=parseInt(intVer)
>if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" &&
>intVer>="5" ) {
>validateOWC();
>}
>else {
>strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0
>height='8'><TR>"
>strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD
>bgColor='#666666' width=500px><FONT face=Tahoma "
>strMsgGetIE+="size=4 color=white><b> Data Access Page
>Notification</B></FONT></TD></TR>"
>strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD
>bgColor='#cccccc' width=500px>
"
>strMsgGetIE+="<p><font face='Tahoma' size='2'>"
>strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
>strMsgGetIE+="<a
>href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p
>align='center'>"
>strMsgGetIE+="Click here to install the latest version of Internet
>Explorer.</a></font></p><br></TD></TR></TABLE>"
>document.write(strMsgGetIE)
>}
>}
>
>function validateOWC() {
>if (MSODSC.object==null) {
>strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0
>height='8'>"
>strMsgGetOWC+="<TR><TD bgColor='#336699' height=25
>width=15> </TD><TD bgColor='#666666' width=500px>"
>strMsgGetOWC+="<FONT face=Tahoma color=white size=4><B>  "
>strMsgGetOWC+="Data Access Page
>Notification</B></FONT></TD></TR><TR><TD bgColor='#cccccc'
>width=15> </TD>"
>strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'>
"
>strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the
>Microsoft Office Web Components.</p>"
>strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a
>HRef='http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?&HelpLCID=1033'>Microsoft
>Office Web site</a> for more information. "
>strMsgGetOWC+="</font></p>
</TD></TR></TABLE>"
>document.write(strMsgGetOWC)
>}
>}
>
></SCRIPT>
><!--[if gte mso 9]><xml>
><o:DocumentProperties>
><o:LastAuthor>Rick C</o:LastAuthor>
><o:Revision>9</o:Revision>
><o:TotalTime>4</o:TotalTime>
><o:LastSaved>2004-12-17T23:37:58Z</o:LastSaved>
><o:Version>10.2625</o:Version>
></o:DocumentProperties>
><o:OfficeDocumentSettings>
><o:DownloadComponents/>
><o:LocationOfComponents HRef="file:///D:\"/>
></o:OfficeDocumentSettings>
></xml><![endif]-->
><SCRIPT language=vbscript event=onbeforeunload for=SerialNumber>
><!--
>
>
>-->
></SCRIPT>
>
><SCRIPT language=vbscript event=onafterupdate for=SerialNumber>
><!--
>
>msgbox "test"
>
>-->
></SCRIPT>
>
><SCRIPT language=vbscript event=onclick for=SerialNumber>
><!--
>
>msgbox "click"
>
>-->
></SCRIPT>
></HEAD>
><BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
><DIV class=Mso2dSectionBanner id=CaptionWarehouseTableBanner
>style="WIDTH: 4.615in" tabIndex=-1><SPAN
>id=CaptionWarehouseTableBannerCaption>Caption:
>WarehouseTable</SPAN></DIV>
><DIV class=Mso2dSection id=CaptionWarehouseTable
>style="WIDTH: 4.615in; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE:
>none; BORDER-LEFT-STYLE: none; HEIGHT: 0in; BACKGROUND-COLOR: #ece9d8;
>BORDER-BOTTOM-STYLE: none"></DIV>
><DIV class=Mso2dSectionBanner id=HeaderWarehouseTableBanner
>style="WIDTH: 4.615in" tabIndex=-1><SPAN
>id=HeaderWarehouseTableBannerCaption>Header:
>WarehouseTable</SPAN></DIV>
><DIV class=Mso2dSection id=HeaderWarehouseTable
>style="WIDTH: 4.615in; BORDER-TOP-STYLE: none; BORDER-BOTTOM: black 1px
>solid; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; HEIGHT:
>1.594in; BACKGROUND-COLOR: #ece9d8"><TEXTAREA class="MsoTextbox Style0"
>id=ID style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX: 2; LEFT:
>1.156in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH: 1.02in;
>PADDING-TOP: 1px; POSITION: absolute; TOP: 0.072in; HEIGHT: 0.197in"
>tabIndex=0 MsoTextAlign="General"></TEXTAREA>
><SPAN class="MSTheme-Label Style1" id=ID_Label
>style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX: 1; LEFT:
>0.041in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH: 1.083in;
>PADDING-TOP: 1px; POSITION: absolute; TOP: 0.083in; HEIGHT: 0.177in"
>MsoTextAlign="General">ID </SPAN><TEXTAREA class="MsoTextbox Style0"
>id=SerialNumber style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX:
>4; LEFT: 1.156in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH:
>1.625in; PADDING-TOP: 1px; POSITION: absolute; TOP: 0.322in; HEIGHT:
>0.197in" tabIndex=1 MsoTextAlign="General"></TEXTAREA>
><SPAN class="MSTheme-Label Style1" id=SerialNumber_Label
>style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX: 3; LEFT:
>0.041in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH: 1.083in;
>PADDING-TOP: 1px; POSITION: absolute; TOP: 0.333in; HEIGHT: 0.177in"
>MsoTextAlign="General">SerialNumber </SPAN></DIV>
><DIV class=Mso2dSectionBanner id=NavigationWarehouseTableBanner
>style="WIDTH: 4.615in" tabIndex=-1><SPAN
>id=NavigationWarehouseTableBannerCaption>Navigation:
>WarehouseTable</SPAN></DIV>
><DIV class=Mso2dSection id=NavigationWarehouseTable
>style="WIDTH: 4.615in; POSITION: relative; HEIGHT: 0.4in">
><TABLE class=MsoNavContainer id=WarehouseTableNavigation
>style="LEFT: 4px; WIDTH: 2.812in; POSITION: absolute; TOP: 4px"
>cellSpacing=0
>cellPadding=0>
><TBODY>
><TR>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavFirst id=WarehouseTableNavFirst tabIndex=1 height=20
>src="owc://GIF/#11200" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavPrevious id=WarehouseTableNavPrevious tabIndex=2
>height=20
>src="owc://GIF/#11202" width=20></TD>
><TD style="VERTICAL-ALIGN: middle; WIDTH: 100%; TEXT-ALIGN: center"
>
>noWrap><SPAN class=MsoNavRecordsetLabel id=WarehouseTableNavLabel
>
>style="VISIBILITY: hidden">WarehouseTable |0-|1 of |2</SPAN></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavNext id=WarehouseTableNavNext tabIndex=4 height=20
>src="owc://GIF/#11204" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavLast id=WarehouseTableNavLast tabIndex=5 height=20
>src="owc://GIF/#11206" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavAddNew id=WarehouseTableNavNew tabIndex=6 height=20
>src="owc://GIF/#11208" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavDelete id=WarehouseTableNavDelete tabIndex=7
>height=20
>src="owc://GIF/#11210" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavSave id=WarehouseTableNavSave tabIndex=8 height=20
>src="owc://GIF/#11214" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavUndo id=WarehouseTableNavUndo tabIndex=9 height=20
>src="owc://GIF/#11212" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavSortAsc id=WarehouseTableNavSortAscending tabIndex=10
>
>height=20 src="owc://GIF/#11216" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavSortDesc id=WarehouseTableNavSortDescending
>tabIndex=11
>height=20 src="owc://GIF/#11218" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavFilter id=WarehouseTableNavFilterBySelection
>tabIndex=12
>height=20 src="owc://GIF/#11220" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavToggleFilter id=WarehouseTableNavFilterToggle
>tabIndex=13
>height=20 src="owc://GIF/#11222" width=20></TD>
><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>class=MsoNavHelp id=WarehouseTableNavHelp tabIndex=14 height=20
>src="owc://GIF/#11224"
>width=20></TD></TR></TBODY></TABLE></DIV></BODY></HTML>

Archived from groups: microsoft.public.pocketpc (More info?)

I think though that the question at hand, which hasn't been asked is
simple - What is the specific need to use Data Access Pages? What is the
requirement or underlying need? Without asking that question, its like
saying that I need to go from New York to London by strech limo. Yes, it
is possible* but the logistics make it utterly absurd.

David H

*By sitting in the strech as its flown or shipped by boat.

Neil Smith [MVP Digital Media] wrote:
> Thanks, I tried it myself yesterday and I can see several areas which
> will lock you out on PPC : They are listed below.
>
> So I'm afraid you'll never get this working on a PPC, using *any*
> browser, though it's perfectly possible to get data access controls
> working on PPC, and it doesn't require this shoddy MS-IE-Office-only
> coding to do it.
>
> Let's think again :
>
> You have a PC with an access database on it. And one or more Pocket
> PCs, and that's connected to the PC how ?
>
> Let's work from there.
>
> Are you in a position where you can export the access database
> regularly, lets say Save-As as XML data, and publish it on a
> private/internal web server, or on an accessible network path (eg
> \\mymachine\shared\database\daptest.xml) ?
>
> Cheers - Neil
>
>
> ========================================
> Local file path reference "Source=C:\daptest.mdb"
>
>
> Unsupported Active X control (Office data source)
> <OBJECT id=MSODSC classid=CLSID:0002E553-0000-0000-C000-000000000046>
>
>
> Explicit non-IE5 or later lockout script :
> function validateBrowser() {
> // ..... etc
> if (strName=="Microsoft Internet Explorer" && strPlat=="Win32"
> && intVer>="5" ) {
> validateOWC();
> }
>
>
> Implicit requirement for Active X controls :
> function validateOWC() {
> if (MSODSC.object==null) {
> // ..... etc
> }
>
>
> Explicit (conditional comments) requirement for MS Office (v9) web
> controls to be installed on the PPC (or pocket PCm, which you can't
> do)
>
> <!--[if gte mso 9]>
> <xml>
> <!-- Other data -->
> </xml>
> <![endif]-->
>
> And the icing on the cake, even the images requre Office to be
> installed (it's an internal "office" pathname) :
>
> <img src="owc://GIF/#11220 />
>
> ========================================
>
>
>
> On 17 Dec 2004 15:44:40 -0800, rickcheney@gmail.com wrote:
>
>
>>Here's the HTML code, (actually it's supposed to be DHTML, Dynamic
>>HTML). Sorry, it's a lot of code but the page is a very simple page.
>>----------------------------------------------------------
>><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>><HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns =
>>"urn:schemas-microsoft-comfficeffice" xmlns:a =
>>"urn:schemas-microsoft-comffice:access" xmlns:x =
>>"urn:schemas-microsoft-comffice:excel" xmlnst =
>>"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>WarehouseTable</TITLE>
>><META content="HTML 4.0" name=vs_targetSchema><LINK
>>href="DAPWarehouseFormTEST_files/filelist.xml" type=text/xml
>>rel=File-List>
>><META content=Access.Application name=ProgId>
>><META name=VBSForEventHandlers value="true">
>><META http-equiv=Content-Type content=text/html;charset=UTF-8>
>><META content=10.00.2225 name=DesignerVersion>
>><OBJECT id=MSODSC tabIndex=-1
>>classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM
>>NAME="XMLData" VALUE='<xml
>>xmlns:a="urn:schemas-microsoft-comffice:access">
>><aataSourceControl> <aWCVersion>10.0.0.2621
>></aWCVersion> <a:MaxRecords>0</a:MaxRecords>
>><a:GridX>24</a:GridX> <a:GridY>24</a:GridY>
>><afflineType>2</afflineType>
>><a:XMLLocation>0</a:XMLLocation>
>><a:XMLDataTarget></a:XMLDataTarget>
>><a:ConnectionFile></a:ConnectionFile> <aatamodel
>>a:version="0816"> </aatamodel>
>></aataSourceControl> </xml>'>
>>PARAM NAME="XMLData" VALUE="<xml
>>xmlns:a="urn:schemas-microsoft-com:office:access">
>><aataSourceControl> <a:OWCVersion>10.0.0.2621
>></a:OWCVersion>
>><a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
>>
>>Source=C:\daptest.mdb;Mode=Share Deny None;Extended
>>Properties=&quot;&quot;;Persist Security Info=False;Jet
>>OLEDB:System
>>database=&quot;&quot;;Jet OLEDB:Registry
>>Path=&quot;&quot;;Jet
>>OLEDBatabase Password=&quot;&quot;;Jet OLEDB:Engine
>>Type=0;Jet
>>OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
>>OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
>>Password=&quot;&quot;;Jet OLEDB:Create System
>>Database=False;Jet
>>OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on
>>Compact=False;Jet
>>OLEDB:Compact Without Replica Repair=False;Jet
>>OLEDB:SFP=False</a:ConnectionString>
>><a:MaxRecords>10000</a:MaxRecords>
>><a:GridX>24</a:GridX>
>><a:GridY>24</a:GridY>
>><a:OfflineType>2</a:OfflineType>
>><a:XMLLocation>0</a:XMLLocation>
>><a:XMLDataTarget></a:XMLDataTarget>
>><a:ConnectionFile></a:ConnectionFile>
>><a:ElementExtension>
>><a:ElementID>ID</a:ElementID>
>><a:ControlSource>ID</a:ControlSource>
>><a:ChildLabel>ID_Label</a:ChildLabel>
>></a:ElementExtension>
>><a:ElementExtension>
>><a:ElementID>SerialNumber</a:ElementID>
>><a:ControlSource>SerialNumber</a:ControlSource>
>><a:ChildLabel>SerialNumber_Label</a:ChildLabel>
>></a:ElementExtension> <a:ElementExtension>
>><a:ElementID>WarehouseTableNavLabel</a:ElementID>
>><a:RecordsetLabel>WarehouseTable |0 of |2;WarehouseTable |0-|1 of
>>|2</a:RecordsetLabel> </a:ElementExtension>
>><a:GroupLevel>
>><a:RecordSource>WarehouseTable</a:RecordSource>
>><aefaultSort></a:DefaultSort>
>><a:HeaderElementId>HeaderWarehouseTable</a:HeaderElementId>
>>
>><a:FooterElementId></a:FooterElementId>
>><a:CaptionElementId>CaptionWarehouseTable</a:CaptionElementId>
>>
>><a:RecordNavigationElementId>NavigationWarehouseTable</a:RecordNavigationElementId>
>>
>><a:DataPageSize>1</a:DataPageSize>
>><a:GroupFilterControl></a:GroupFilterControl>
>><a:RecordSelector/> </a:GroupLevel> <a:Datamodel
>>a:version="0816"> <a:SchemaRowsource
>>a:id="WarehouseTable" a:type="dscTable">
>>
>><a:SchemaField a:id="ID" a:datatype="3"
>>a:size="0"
>>a:iskey="1"/> <a:SchemaField
>>a:id="SerialNumber" a:datatype="130"
>>a:size="50"/> <a:SchemaField
>>a:id="Model"
>>a:datatype="130" a:size="50"/>
>><a:SchemaField
>>a:id="CosmeticCondition" a:datatype="130"
>>a:size="50"/> <a:SchemaField
>>a:id="Make"
>>a:datatype="130" a:size="50"/>
>><a:SchemaField
>>a:id="Ports" a:datatype="130"
>>a:size="50"/> </a:SchemaRowsource>
>><a:RecordsetDef a:id="WarehouseTable">
>><aageField
>>a:id="ID"/> <aageField
>>a:id="SerialNumber"/> </a:RecordsetDef>
>>
>></a:Datamodel>
>></a:DataSourceControl> </xml>"></OBJECT>
>><STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
>>BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
>>3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in;
>>BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN:
>>left
>>}
>>.MsoTextbox {
>>PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW:
>>hidden; WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
>>}
>>.MsoBoundSpan {
>>BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
>>3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM:
>>0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
>>}
>>.MsoHyperlinkDisplayText {
>>BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT:
>>3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand;
>>BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
>>}
>>.Mso2dSection {
>>LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden;
>>POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
>>}
>>.Mso2dSectionBanner {
>>PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT:
>>normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR:
>>url(#DEFAULT#Mso2dSectionBanner); PADDING-TOP: 2px; FONT-FAMILY:
>>Tahoma; TOP: 0px; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface
>>}
>>.MsoRectangle {
>>BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW:
>>hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
>>}
>>.MsoTitle {
>>DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
>>}
>>.MsoExpandCollapse {
>>CURSOR: hand
>>}
>>.MsoNavContainer {
>>BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
>>Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand;
>>BORDER-BOTTOM: gainsboro 1px solid; POSITION: absolute; HEIGHT: 25px;
>>BACKGROUND-COLOR: gainsboro
>>}
>>.MsoNavButton {
>>BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
>>BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM:
>>gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
>>}
>>.MsoNavButtonMouseOver {
>>BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid;
>>BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid;
>>BACKGROUND-COLOR: buttonhighlight
>>}
>>.MsoNavToggleButtonMouseOver {
>>BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid;
>>BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid;
>>BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonhighlight
>>}
>>.MsoNavButtonMouseDown {
>>BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
>>solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand;
>>BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
>>}
>>.MsoNavRecordsetLabel {
>>BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid;
>>PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT:
>>gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px;
>>BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma
>>}
>>.MsoRecordSelector {
>>BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
>>solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; WIDTH:
>>0.17in; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%;
>>BACKGROUND-COLOR: gainsboro
>>}
>>.MsoRecordSelectorCurrent {
>>BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11240);
>>BACKGROUND-REPEAT: no-repeat
>>}
>>.MsoRecordSelectorSelectedImage {
>>BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11241);
>>BACKGROUND-REPEAT: no-repeat
>>}
>>.MsoRecordSelectorSelected {
>>BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px
>>solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px
>>solid; WIDTH: 0.17in; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px;
>>HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow; POSTION: relative
>>}
>>.MsoRecordSelectorDirty {
>>BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE:
>>url(owc://GIF/#11242); BACKGROUND-REPEAT: no-repeat
>>}
>>.MsoRecordSelectorTransparent {
>>LEFT: 0px; OVERFLOW: hidden; WIDTH: 0.17in; TOP: 0px; POSTION:
>>relative
>>}
>>HR {
>>COLOR: black
>>}
>>SELECT {
>>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>>}
>>INPUT {
>>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>>}
>>BODY {
>>FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
>>}
>>MARQUEE {
>>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>>}
>>LEGEND {
>>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>>}
>>BUTTON {
>>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>>}
>>TEXTAREA {
>>FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
>>}
>>.Style0 {
>>BORDER-RIGHT: transparent 2px inset; BORDER-TOP: transparent 2px
>>inset; FONT-WEIGHT: 400; FONT-SIZE: 8pt; VISIBILITY: visible;
>>BORDER-LEFT: transparent 2px inset; COLOR: #000000; BORDER-BOTTOM:
>>transparent 2px inset; FONT-STYLE: normal; FONT-FAMILY: MS Sans Serif;
>>WRITING-MODE: lr-tb; BACKGROUND-COLOR: #ffffff
>>}
>>.Style1 {
>>BORDER-RIGHT: #000000 1px; BORDER-TOP: #000000 1px; FONT-WEIGHT: 400;
>>FONT-SIZE: 8pt; VISIBILITY: visible; BORDER-LEFT: #000000 1px; COLOR:
>>#000000; BORDER-BOTTOM: #000000 1px; FONT-STYLE: normal; FONT-FAMILY:
>>MS Sans Serif; WRITING-MODE: lr-tb; BACKGROUND-COLOR: transparent
>>}
>></STYLE>
>>
>><META content="MSHTML 6.00.2600.0" name=GENERATOR>
>><SCRIPT language=Javascript id=MSODSC_Validation>
>>validateBrowser();
>>
>>function validateBrowser() {
>>strVers=navigator.appVersion
>>strName=navigator.appName
>>strPlat=navigator.platform
>>intIndex1=strVers.indexOf("MSIE" );
>>intIndex1=intIndex1+5
>>intIndex2=strVers.lastIndexOf(";" );
>>intVer=strVers.substring(intIndex1, intIndex2)
>>intVer=parseInt(intVer)
>>if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" &&
>>intVer>="5" ) {
>>validateOWC();
>>}
>>else {
>>strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0
>>height='8'><TR>"
>>strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD
>>bgColor='#666666' width=500px><FONT face=Tahoma "
>>strMsgGetIE+="size=4 color=white><b> Data Access Page
>>Notification</B></FONT></TD></TR>"
>>strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD
>>bgColor='#cccccc' width=500px>
"
>>strMsgGetIE+="<p><font face='Tahoma' size='2'>"
>>strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
>>strMsgGetIE+="<a
>>href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p
>>align='center'>"
>>strMsgGetIE+="Click here to install the latest version of Internet
>>Explorer.</a></font></p><br></TD></TR></TABLE>"
>>document.write(strMsgGetIE)
>>}
>>}
>>
>>function validateOWC() {
>>if (MSODSC.object==null) {
>>strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0
>>height='8'>"
>>strMsgGetOWC+="<TR><TD bgColor='#336699' height=25
>>width=15> </TD><TD bgColor='#666666' width=500px>"
>>strMsgGetOWC+="<FONT face=Tahoma color=white size=4><B>  "
>>strMsgGetOWC+="Data Access Page
>>Notification</B></FONT></TD></TR><TR><TD bgColor='#cccccc'
>>width=15> </TD>"
>>strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'>
"
>>strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the
>>Microsoft Office Web Components.</p>"
>>strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a
>>HRef='http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?&HelpLCID=1033'>Microsoft
>>Office Web site</a> for more information. "
>>strMsgGetOWC+="</font></p>
</TD></TR></TABLE>"
>>document.write(strMsgGetOWC)
>>}
>>}
>>
>></SCRIPT>
>><!--[if gte mso 9]><xml>
>><o:DocumentProperties>
>><o:LastAuthor>Rick C</o:LastAuthor>
>><o:Revision>9</o:Revision>
>><o:TotalTime>4</o:TotalTime>
>><o:LastSaved>2004-12-17T23:37:58Z</o:LastSaved>
>><o:Version>10.2625</o:Version>
>></o:DocumentProperties>
>><o:OfficeDocumentSettings>
>><o:DownloadComponents/>
>><o:LocationOfComponents HRef="file:///D:\"/>
>></o:OfficeDocumentSettings>
>></xml><![endif]-->
>><SCRIPT language=vbscript event=onbeforeunload for=SerialNumber>
>><!--
>>
>>
>>-->
>></SCRIPT>
>>
>><SCRIPT language=vbscript event=onafterupdate for=SerialNumber>
>><!--
>>
>>msgbox "test"
>>
>>-->
>></SCRIPT>
>>
>><SCRIPT language=vbscript event=onclick for=SerialNumber>
>><!--
>>
>>msgbox "click"
>>
>>-->
>></SCRIPT>
>></HEAD>
>><BODY style="OVERFLOW: auto" vLink=#800080 link=#0000ff>
>><DIV class=Mso2dSectionBanner id=CaptionWarehouseTableBanner
>>style="WIDTH: 4.615in" tabIndex=-1><SPAN
>>id=CaptionWarehouseTableBannerCaption>Caption:
>>WarehouseTable</SPAN></DIV>
>><DIV class=Mso2dSection id=CaptionWarehouseTable
>>style="WIDTH: 4.615in; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE:
>>none; BORDER-LEFT-STYLE: none; HEIGHT: 0in; BACKGROUND-COLOR: #ece9d8;
>>BORDER-BOTTOM-STYLE: none"></DIV>
>><DIV class=Mso2dSectionBanner id=HeaderWarehouseTableBanner
>>style="WIDTH: 4.615in" tabIndex=-1><SPAN
>>id=HeaderWarehouseTableBannerCaption>Header:
>>WarehouseTable</SPAN></DIV>
>><DIV class=Mso2dSection id=HeaderWarehouseTable
>>style="WIDTH: 4.615in; BORDER-TOP-STYLE: none; BORDER-BOTTOM: black 1px
>>solid; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; HEIGHT:
>>1.594in; BACKGROUND-COLOR: #ece9d8"><TEXTAREA class="MsoTextbox Style0"
>>id=ID style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX: 2; LEFT:
>>1.156in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH: 1.02in;
>>PADDING-TOP: 1px; POSITION: absolute; TOP: 0.072in; HEIGHT: 0.197in"
>>tabIndex=0 MsoTextAlign="General"></TEXTAREA>
>><SPAN class="MSTheme-Label Style1" id=ID_Label
>>style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX: 1; LEFT:
>>0.041in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH: 1.083in;
>>PADDING-TOP: 1px; POSITION: absolute; TOP: 0.083in; HEIGHT: 0.177in"
>>MsoTextAlign="General">ID </SPAN><TEXTAREA class="MsoTextbox Style0"
>>id=SerialNumber style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX:
>>4; LEFT: 1.156in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH:
>>1.625in; PADDING-TOP: 1px; POSITION: absolute; TOP: 0.322in; HEIGHT:
>>0.197in" tabIndex=1 MsoTextAlign="General"></TEXTAREA>
>><SPAN class="MSTheme-Label Style1" id=SerialNumber_Label
>>style="PADDING-RIGHT: 1px; PADDING-LEFT: 1px; Z-INDEX: 3; LEFT:
>>0.041in; PADDING-BOTTOM: 1px; OVERFLOW: hidden; WIDTH: 1.083in;
>>PADDING-TOP: 1px; POSITION: absolute; TOP: 0.333in; HEIGHT: 0.177in"
>>MsoTextAlign="General">SerialNumber </SPAN></DIV>
>><DIV class=Mso2dSectionBanner id=NavigationWarehouseTableBanner
>>style="WIDTH: 4.615in" tabIndex=-1><SPAN
>>id=NavigationWarehouseTableBannerCaption>Navigation:
>>WarehouseTable</SPAN></DIV>
>><DIV class=Mso2dSection id=NavigationWarehouseTable
>>style="WIDTH: 4.615in; POSITION: relative; HEIGHT: 0.4in">
>><TABLE class=MsoNavContainer id=WarehouseTableNavigation
>>style="LEFT: 4px; WIDTH: 2.812in; POSITION: absolute; TOP: 4px"
>>cellSpacing=0
>>cellPadding=0>
>><TBODY>
>><TR>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavFirst id=WarehouseTableNavFirst tabIndex=1 height=20
>>src="owc://GIF/#11200" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavPrevious id=WarehouseTableNavPrevious tabIndex=2
>>height=20
>>src="owc://GIF/#11202" width=20></TD>
>><TD style="VERTICAL-ALIGN: middle; WIDTH: 100%; TEXT-ALIGN: center"
>>
>>noWrap><SPAN class=MsoNavRecordsetLabel id=WarehouseTableNavLabel
>>
>>style="VISIBILITY: hidden">WarehouseTable |0-|1 of |2</SPAN></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavNext id=WarehouseTableNavNext tabIndex=4 height=20
>>src="owc://GIF/#11204" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavLast id=WarehouseTableNavLast tabIndex=5 height=20
>>src="owc://GIF/#11206" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavAddNew id=WarehouseTableNavNew tabIndex=6 height=20
>>src="owc://GIF/#11208" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavDelete id=WarehouseTableNavDelete tabIndex=7
>>height=20
>>src="owc://GIF/#11210" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavSave id=WarehouseTableNavSave tabIndex=8 height=20
>>src="owc://GIF/#11214" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavUndo id=WarehouseTableNavUndo tabIndex=9 height=20
>>src="owc://GIF/#11212" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavSortAsc id=WarehouseTableNavSortAscending tabIndex=10
>>
>>height=20 src="owc://GIF/#11216" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavSortDesc id=WarehouseTableNavSortDescending
>>tabIndex=11
>>height=20 src="owc://GIF/#11218" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavFilter id=WarehouseTableNavFilterBySelection
>>tabIndex=12
>>height=20 src="owc://GIF/#11220" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavToggleFilter id=WarehouseTableNavFilterToggle
>>tabIndex=13
>>height=20 src="owc://GIF/#11222" width=20></TD>
>><TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
>>class=MsoNavHelp id=WarehouseTableNavHelp tabIndex=14 height=20
>>src="owc://GIF/#11224"
>>width=20></TD></TR></TBODY></TABLE></DIV></BODY></HTML>
>
>

Archived from groups: microsoft.public.pocketpc (More info?)

Neil, it's a single table like an excel spreadsheet, 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.

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
information is scanned the Serial Number is scanned and the record is
saved. Everything works fine, except, you have to bring the items to
the scanner. For large, heavy items, the idea was to use a mobile data
terminal like HHP Dolphin 7450, running Pocket PC 2002 and to connect
to the database wirelessly (real-time) through a WIFI access point.
The catch seems to be connecting to the database real-time. There are
many inexpensive programs like Data On the Run, Sprint DB Pro, etc.,
that can create forms on the Pocket PC and then collect data and then
update the database automatically when the device is placed into the
cradle. But in order to connect real-time, the cheapest software I
found was Visual CE with mEnable
(http://www.syware.com/prodlib/win_ce/vce/vce.htm) and that is $600.
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.
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?

Archived from groups: microsoft.public.pocketpc (More info?)

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/Ac [...] w.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 spreadsheet, 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 stylesheet, 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 stylesheet 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 stylesheet 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?
>
>

Archived from groups: microsoft.public.pocketpc (More info?)

You have to purchase the .dll file to run ASP. I'm not familiar with
wireless on a PocketPC so I can't answer the real-time issue, however if
you're NOT using wireless I can say definatelivey (sp) that the records
are NOT updated in real-time - you have to sync. If you need real-time
updating, I suspect that you're going to have to spend some money and
that a PocketPC is not what you're looking for. You'll probably want to
go with a TabletPC which would be a full-fledge PC but not as bulky as a
laptop. There are TPC's available that are designed for industrial usage.

David H

rcmail14872@yahoo.com wrote:
> I like the ASP idea, I'm going to test it. I can install IIS on the
> network machine. Will WM 2003 run ASP pages? Or is the ONLY way I can
> run ASP by purchasing a $300 .dll file? If I use DB Anywhere can I
> edit the database table records real-time? Or does DB Anywhere only
> collect the data on the data terminal and then synch when I put the
> data terminal in the cradle?
>

Archived from groups: microsoft.public.pocketpc (More info?)

The default code that Access produces for "Data Access Pages" allows
the user to edit records in the database from a web page viewed in
Internet Explorer. I am still holding out hope that if I return this
brand new data terminal and get a new one with Pocket PC 2003 that the
version of PIE that comes with PPC 2003 might work with Data Access
Pages. If it doesn't then, a) this device is not the best device for
"real-time" data collecting, I'll get a tablet PC instead; or b) just
collect the data (with DB Anywhere) and synch up with the cradle; or c)
last resort - purchase some expensive software to do the real-time
collecting and learn the new coding to make it work.

Archived from groups: microsoft.public.pocketpc (More info?)

And on another note, one other question to ask is wether or not the
amount of work that your putting into this to make it work with a
PocketPC is worth the amount that you're clients are willing to pay.
While it is possible to use a technology in a way not neccessarily
intended, it is not neccessarily the best decision especially if you're
having to bend over backwards and twist around to make it work. At some
point, there is a value to spending money for the right software running
on the right platform or hardware. I'm reminded of an incident where a
person could have spent money to rent a truck, but decided that he could
make do without the truck. This is what happened...

http://www.snopes.com/photos/lumber.asp

David H

David C. Holley wrote:

> You have to purchase the .dll file to run ASP. I'm not familiar with
> wireless on a PocketPC so I can't answer the real-time issue, however if
> you're NOT using wireless I can say definatelivey (sp) that the records
> are NOT updated in real-time - you have to sync. If you need real-time
> updating, I suspect that you're going to have to spend some money and
> that a PocketPC is not what you're looking for. You'll probably want to
> go with a TabletPC which would be a full-fledge PC but not as bulky as a
> laptop. There are TPC's available that are designed for industrial usage.
>
> David H
>
> rcmail14872@yahoo.com wrote:
>
>> I like the ASP idea, I'm going to test it. I can install IIS on the
>> network machine. Will WM 2003 run ASP pages? Or is the ONLY way I can
>> run ASP by purchasing a $300 .dll file? If I use DB Anywhere can I
>> edit the database table records real-time? Or does DB Anywhere only
>> collect the data on the data terminal and then synch when I put the
>> data terminal in the cradle?
>>