Intranet Database

[Rooster]

Hi

I am trying to develop an intranet for users here in my office. I would like them to be able to have acess to our library database via their web browsers. I have written a test DHTML page with VB 6.0 and can connect to the db from my machine. However, when I copy the generated files to another machine, it does not connect to the db.

I created a text field and a button on the DHTML page and attached the following code to the button:

Dim db As Database
Dim rs As Recordset
Dim syear As String
Set db = OpenDatabase("c:\test\biblio.mdb")
Set rs = db.OpenRecordset("authors")
TextField1.Value = rs.Fields("author").Value

This code in theory should display the first feild of the db.

Can anyone help me as to why it only works from my machine and not on the other machine?

Thanks
Rudi

[bashfirst]

I'm not familiar with DHTML, but if you are trying to open a database on the C drive, it should only work on your machine where the database exists, right?

Bash