ASP for Access 2000

[Terry VanDuzee]

Hello
I have no clue as to how to create asp pages. All I know is that I have
placed my Access DB on Brinkster.com and they say I need to be able to use
asp pages to access the database.
I have no problem with access and I have created the 1 form that I need (in
Access 2k).

Scenario:
User visits the site and input data that is placed in my access db. No user
can see any of the data that is in there currently. after they leave the
form, they cannot see any info from the db at all. This is simply for
"input" only.

My default.htm that starts up will have abutton that will call the asp view
of the db (empty fields looking for input). Then, when the user has entered
the info, a button will take them back to the default.htm page.

Here's my problem, I have only 2 days to get this working on the net. I do
not have a clue about asp (although I have done some reading on it....I
cannot learn enough between now and friday to do this.

Can anyone help me out, this is really an emergency situation.

Thank you so much for any help
Terry V

[Ray at]

E-mail me privately if you'd like a quote. ray at lane34 dot com

Ray at home

--
Will trade ASP help for SQL Server help


"Terry VanDuzee" <terryv@nbnet.nb.ca> wrote in message
news:fmITa.16593$jL2.1386609@ursa-nb00s0.nbnet.nb.ca...

> Hello
> I have no clue as to how to create asp pages.
> I have only 2 days to get this working
> I cannot learn enough between now and friday to do this.
>
> Can anyone help me out

[TJS]

You can find asp scripts which create forms and update access tables here:

[url]http://www.aspin.com/func/search?cob=aspkey&qry=table+editor[/url]





"Terry VanDuzee" <terryv@nbnet.nb.ca> wrote in message
news:fmITa.16593$jL2.1386609@ursa-nb00s0.nbnet.nb.ca...

> Hello
> I have no clue as to how to create asp pages. All I know is that I have
> placed my Access DB on Brinkster.com and they say I need to be able to use
> asp pages to access the database.
> I have no problem with access and I have created the 1 form that I need

(in

> Access 2k).
>
> Scenario:
> User visits the site and input data that is placed in my access db. No

user

> can see any of the data that is in there currently. after they leave the
> form, they cannot see any info from the db at all. This is simply for
> "input" only.
>
> My default.htm that starts up will have abutton that will call the asp

view

> of the db (empty fields looking for input). Then, when the user has

entered

> the info, a button will take them back to the default.htm page.
>
> Here's my problem, I have only 2 days to get this working on the net. I

do

> not have a clue about asp (although I have done some reading on it....I
> cannot learn enough between now and friday to do this.
>
> Can anyone help me out, this is really an emergency situation.
>
> Thank you so much for any help
> Terry V
>
>

[Bullschmidt]

Here is something I put together about ASP that hopefully might help
somehow.

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!