Hello, 



I have an ACCESS 97 database that I would to publish to the web, can

anyone tell me the steps on how to do it.  I have personel WEB server

installed, also I know how to connect using ODBC.  How do I load my

database to the web and use the forms the database on the web to update my

database from the web.  I have tried but I can't get it to work.



Thanks

Ken

Check out this book: It will answer all our questions:



http://www.amazon.com/exec/obidos/ASIN/1861002726/qid%3D980437461/105-8520737-7896731





Imar



At 03:26 PM 1/25/2001 +0000, you wrote:

>Hello,

>

>I have an ACCESS 97 database that I would to publish to the web, can

>anyone tell me the steps on how to do it.  I have personel WEB server

>installed, also I know how to connect using ODBC.  How do I load my

>database to the web and use the forms the database on the web to update my

>database from the web.  I have tried but I can't get it to work.

>

>Thanks

>Ken

ken

is suppose you know when your database is running and you can connect with a

html form to your databas and you are connecting over http...(NOT FILE

surfing..) the only thing you need to have is an ip number to connect to the

internet...and a domain ...

So your question troubles me..you know how to connect via odbc..so is your

database running???

is suppose you know VBscript and know how to trigger a loop, getting all

your information out of the database..

something like

****

set conn = Server.CreateObject("ADODB.Connection")

rem set connect info

conn.Connectionstring = "DSN=" & application("OdbcConname") & ";UID=" &

application("OdbcUsername") & ";PWD=" & application("OdbcPassword")

rem open the connection

conn.open

set rs=Server.CreateObject ("Adodb.Recordset)

conn

rs.open  SQL,conn, ,AdcmdTexte

(if connectionstring is open and recordset object is created)

while not rs.eof

	response.write rs.fields("id")

move next

rs.close

conn.close

set rs=nothing

set conn=nothing

...

so here you are..

eric





-----Original Message-----

From: Ken [mailto:ken.mcintosh@s...]

Sent: Thursday, January 25, 2001 3:26 PM

To: ASP Databases

Subject: [asp_databases] ACCESS 97 DAtabase





Hello,



I have an ACCESS 97 database that I would to publish to the web, can

anyone tell me the steps on how to do it.  I have personel WEB server

installed, also I know how to connect using ODBC.  How do I load my

database to the web and use the forms the database on the web to update my

database from the web.  I have tried but I can't get it to work.



Thanks

Ken