access thread: How do I 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=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