Cannot retrieve records from database in other computer

[rongfu84]

hi

i am trying to make a connection to database that are in other computer. But the follow errors occurs: Could not find installable ISAM. btw i am using vb.net

this are the codes:

Dim path As String
mConn = New ADODB.Connection()

path = "server=172.20.144.4;uid=administrator;pwd=;database=Bio.mdb"
mConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & path)


i am not sure whether my codes is correct or not but i koe i cannot connect to that computer. Can any one tell me why?

thanks alot

[mendhak]

I don't think you can use an IP address when trying to connect to an MS Access database. You should use a servername and share path, like this

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=\\myServer\myShare\myPath\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd="

[mendhak]

or if you're using OLEDB...

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\myServer\myShare\myPath\myDb.mdb"

[rongfu84]

hi

i am not too familar with access,
sorry what do u mean by myserver and myshare?

regards