Odbc

Hi,

I have a MSDE database on 1 computer. I have an Access MDB file on the same computer which has table links to the MSDE database. Therefore, I have a SQL Server DSN on that computer.

Now, if I want to access that MDB file from a different computer on the network, it tells me that I need a DSN there as well.

Is there any way that I can do this without having to create a DSN on each workstation that will be accessing the MDB file?

Thanks,

You could use a DNS-Less connection so that you dont have to specify a System DNS on each workstation.

A standard DNS-Less type of connection would like somewhat like this:

Code:

---

Set conn = New ADODB.Connection

conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="\\workstation\database.mdb"))

---

This help?

I have to use DAO though.

That doesn't matter