Mr. Kriangsak, I'm having the same problem accessing an Access database on 

a shared drive using ASP. VB, dll all work fine. Did you ever solve this? 

Thanks,



Frank



> How do  I join MsAccess via OLE DB include Workgroup File (system.mdw) .

> 

> Do I need to used IIS version 5.0 in Microsoft 2000 Server.

> 

> I used MS Access 97 include system database workgroup file (system.mdw) 

> and Use  below ASP Code .....

> 

> Connection.asp

> 

> <%

>   Set conn =3D Server.CreateObject("ADODB.Connection")

>   conn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data 

> Source=3D\\sfbkkho5\Vnwhome\vnwPCHO.mdb;

> 

>   Jet OLEDB:System database=3D\\sfbkkho5\Vnwhome\system.mdw;User  

> ID=3DAdmin;Passwprs=3D xxxx"

> Set rs =3D Server.CreateObject("ADODB.Recordset")

> %>

> 

> JOB.ASP

> 

> <!--#include file =3Dconnection.asp-->

> <%

>   sql =3D "SELECT * from TabZoneArea"

>   rs.Open sql, conn, 3, 3

>   rs.MoveFirst

> %>................

> 

> ...........................

> 

> If I write this code will it display error code below?

> 

> Error Type:

> Microsoft JET Database Engine (0x80004005)

> The Microsoft Jet database engine cannot open the file ''. It is already 



> opened exclusively by another user, or you need permission to view its 

> data.

> /connection.asp, line 3

> 

> But If I try to write code in Microsoft Windows 98 with PWS it will 

> work.

> 

> 

> 

> Thank you.....

> 

> Kriangsak.S/ Service Engineer