Data Access Page vs ASP

[Richard Choate]

I'm really new to the concepts of Data Access Pages and asp, but I have been
an Access developer for some time(just not a web/Access developer). I
started by trying to convert a userform to a DAP and then tried going to
ASP. Both results sucked. I read help at that point and learned that DAP
doesn't support very much of the stuff my forms do. This leads me to some
questions:

Could somebody tell me the primary differences between DAP and ASP?

Will asp come close to providing the functionality of my original Access
forms, including my code?

If no, will anything allow me to use my forms on a website?

Do you have any words of advice that I would be wise to heed?

Thanks !

Richard Choate, CPA

[Tammy B.]

there are some major setup issues if you try to do that over the internet or
intranet. that could be your problem. There are articles out there on that.



"Richard Choate" <rchoatecpa@NoSpam.com> wrote in message
news:O5xIjHzTDHA.2180@TK2MSFTNGP10.phx.gbl...

> I'm really new to the concepts of Data Access Pages and asp, but I have

been

> an Access developer for some time(just not a web/Access developer). I
> started by trying to convert a userform to a DAP and then tried going to
> ASP. Both results sucked. I read help at that point and learned that DAP
> doesn't support very much of the stuff my forms do. This leads me to some
> questions:
>
> Could somebody tell me the primary differences between DAP and ASP?
>
> Will asp come close to providing the functionality of my original Access
> forms, including my code?
>
> If no, will anything allow me to use my forms on a website?
>
> Do you have any words of advice that I would be wise to heed?
>
> Thanks !
>
> Richard Choate, CPA
>
>

[Richard Choate]

Thank for the great information !

I appreciate it and I will study all of the items you mentioned.

Thanks again.
Richard Choate

"Bullschmidt" <paul@bullschmidt.com-nospam> wrote in message
news:unbH5N4TDHA.940@TK2MSFTNGP11.phx.gbl...
It's just the limited nature of data access pages that the user's
computer needs to be able to establish a client-side connection to the
database. That's why it isn't really used much on the Internet.

And for your info here is my take on putting a database on the Web
WITHOUT requiring the user to have a copy of the database on his or her
PC.
You and others can have access to a database hosted on the Web from any
location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do
work in various locations in or outside the office and still be
"plugged" in.

For example you could have employees enter timesheets or have sales reps
log their contacts. Or perhaps you'd like customers to be able to check
the status of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a
database such as Access or MySQL (basically just consisting of tables)
would be put on the Web.

Then "dynamic" Web pages (actually ASP pages which include VBScript,
HTML, and/or JavaScript) would be created acting like the old desktop
database's queries, forms, and reports to access the database - all
hosted on a Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages. But
they are "live" because the user can read from and write to information
in the database. An example where you can login and add, edit, or view
fictional customers and invoices is at
[url]http://www.bullschmidt.com/login.asp[/url]

Not all Web hosts will handle dynamic Web pages but many do. The Web
hosts that can handle ASP pages usually have a Windows 2000 operating
system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - [url]http://www.asp101.com/samples[/url]
o W3Schools ASP Tutorial - [url]http://www.w3schools.com/asp[/url]
o Microsoft VBScript Language Reference -
[url]http://msdn.microsoft.com/scripting/default.htm?/scripting/VBScript/doc/[/url]
vbscripttoc.htm

And the following newsgroup is good:
microsoft.public.inetserver.asp.general

Or for a "quick and dirty" generic ASP solution to putting database
tables on the Web that just requires setting up a configuration page for
each table or query and uploading the database to the Web as long as you
have an autonumber field in each table (and as a more advanced issue
you'll probably sometime in the future want to create login
capabilities), perhaps try something like this:
GenericDB by Eli Robillard
[url]http://www.genericdb.com[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!