putting Access database on Internet

[sunnywink]

Hi all,

I am given this task to put up Access database on to the Internet, such as people from different regions can enter to update on this database.

I would like to create a web page first and putting the database up. I understand that I need to expoart the form to *.asp form but am stuck from then.

Does anyone have idea how can I create the web page and put up the form on internet? We do not have MS FrontPage program on our computers and need to create webpage from stratch.

Thanks for your help.

 

[blueark]

If you're using ASP, you need to do a few things. Firstly you need a connection string (this will vary from system to system, so check with your ISP). Then you'll need to open the connection, probably execute some SQL commands, and close the connection. Code would look something like:

<%
ConnectionString = &quot;[red]your connection string[/red]&quot;
SQLstring = &quot;[red]you SQL command[/red]&quot;

Set Con = Server.CreateObject(&quot;ADODB.Connection&quot
Con.Open (ConnectionString)

Set RS = Con.Execute (SQLString)

DO WHILE NOT RS.EOF
[red]Process the results[/red]
LOOP

Con.Close
Set Con=Nothing
%>

You could also check out

http://www.aspfaq.com

for more details.

 

[TonyU]

[tt]

Or visit us at the ASP forum. We'll take care of you.

* * * * * * * * * * *
<%=Tony%>

​

 

[sera]

or go to

http://www.w3schools.com

for a great tutorial on asp.
Sera
I often believe that...
My computer is possessed!