Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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


Message #1 by "kriangsak Sribahn" <kriangsak.s@t...> on Wed, 25 Jul 2001 02:48:32
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=Server.CreateObject("ADODB.Connection")

conn.Open ""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\sfbkkho5

\Vnwhome\vnwPCHO.mdb;Jet OLEDB:System database=\\sfbkkho5

\Vnwhome\system.mdw;User  ID=Admin;Passwprs= xxxx"

Set rs=Server.CreateObject("ADODB.Recordset")

%>



JOB.ASP



<!--#include file =connection.asp-->

<% 

  sql = "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






  Return to Index