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

[preeti]

Hi,

Check the path for you database...

In theory your c: drive is a local drive on your machine, so if you are trying to access a database on another machine then the drive would not be c: but another letter that represents a virtual drive to where the database is actually located.

HTH,

Preeti