drop-down list box on Data Access Page

[JED]

I want to use a drop-down list box on a Data Access Page, but I am concerned
how the control will work on client computers that do not have Office
installed, but have the minimum requirement of Office Web Components
installed. This is important, since I would like to publish a page using this
control on the internet.

The Knowledge Base article 288729 is not explicitly clear on how IE handles
Data Access Pages when the client computer does not have MS Office installed
but only has the Office Web Components installed. In this case IE works in
"run-time static" mode. The article indicates that pages cannot be used to
“update†a database, but “view†only. The article also seems to indicate that
many of the controls are view only or will not work. My question is:
"Will a Drop-down List box work in this situation"? "Will the user still be
able to click on the box and select from the list (not to update the
database, but so script can determine what to display)"?

 

[Sylvain Lafontaine]

The "run-time static" mode is not for all Office Web Components and exclude
the Data OWC; so your code with the Drop-down List box should work fine if
the client computer does not have MS Office installed (in my opinion).

However, before continuing your work, you should make sure that your current
ISP will offers support for accessing the MSDE or SQL-Server from the
outside, ie. that it will not block the port 1433 with a firewall.

Of course, if you are the proud owner of your own web server or want to use
an Intranet or a VPN, then the last comment doesn't apply to you.

S. L.

 

[Sylvain Lafontaine]

There is also a newsgroup about DAP: m.p.a.dataaccess.pages

S. L.

 

[JED]

The ISP side is being looked into as we speak. I need to nail down some
details on data access pages, especially this aspect of IE's "runtime static
mode". Thx for the assist. I will try the newsgroup.