Hello all,

i have difficulties to access data, which is in my desktop, from my laptop
under is my code:

'adoCon.Open "Provider=SQLOLEDB; DRIVER={Microsoft Access Driver (*.mdb)}; Data Source=192.168.0.117; DBQ=" & Server.MapPath("Tables.mdb") & ";"

i got error like this:

error type¡G
Microsoft OLE DB Provider for SQL Server (0x80004005)
invalid connection string

can any one give me some suggestion

Try something like:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\iissamples\sdk\asp\database\Auth ors.mdb;Persist Security Info=False"

Your provider is referencing the sql server oledb provider not access.

Thanx rnealejr,

i just succeed this morning, and here is my example, which can share with u guys as an example...^^

adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\IP_address\...file_path\Tables.mdb;" & _
"Jet OLEDBatabase Password=my_password;"

the other question is:

Is it possible to read mdb file while that file is openned...??