Hello,
I am looking for some advice on whether to use Data Access Pages. Basically
they will be used on a organization's intranet. The pages will be a simple
survey, about 20-40 questions, where the users will select an answer for
each question. The number of individuals answering questions is between
50 - 75.
Data Access Pages appear to the simplest way to obtain the needed
functionality, but they are not pretty. I will be using Access 2000.
Suggestions, recommendations, anecdotes, thoughts, warnings, etc. are
appreciated.
Lyle Fairfield - 09 Feb 2006 05:53 GMT
I often design a form when I want a DAP. Then I save (or export, can't
remember which) the form as a DAP. I find it easier to make the form
"pretty" and to include all the capabilities that I want in form design
than in DAP design.
My biggest disappointment with DAPs is when I try to use them as
continuous forms for a large number of records. I have not found a way
to show say ten records and smoothly scroll down or up. Yes, I know I
can control this with code and ADO pages etc, etc, but if I'm going to
do this I might just as well do a bit more and code the whole thing as
ASP or HTA; then I am no longer dependent on Internet Explorer nor on
Office Web Extensions.
If the users have Access 2000 you could use an ADP quite easily.
Security concerns and some very bizarre multiple connections have made
me abandon ADP use for anything other than trivial utility type things,
but you will know whether this is a problem for your internet.
Lyle Fairfield - 09 Feb 2006 05:54 GMT