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

  ----- Original Message -----

  From: Mr.Kriangsak Sribahn

  To: access_asp@p...

  Sent: Tuesday, July 24, 2001 2:29 PM

  Subject: Join MsAccess via OLE DB include Workgroup File (system.mdw)





  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.



  My database  is \\SFBKKHO5 \vnwhome\vnwpcho.mdb.



  My system database is \\SFBKKHO5 \vnwhome\system.mdw.



  I used MS Access 97 include system database workgroup file 

(system.mdw) and Use  below ASP Code .....



  Connection.asp



  <%

  Set conn=3DServer.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=3DServer.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.



   Please Help Me....



  Thank you.....



  Kriangsak.S/ Service Engineer