I am asking for help now that it works on one computer but now it doesn't want to work and I'm asking for ideas/help. Ok here is the problem. I made two ASP files on is a simple form just to ask a person to enter a Number then click submit to send the number to the second ASP file that will return a table of records or say no records found. Here is the Source code of the second ASP:
<HTML>
<HEAD>
<TITLE>Inspection Results</TITLE>
</HEAD>
<BODY>
<CENTER><Font Size =5><BOLD>Inspection Results</BOLD></FONT></CENTER>
<P>
<%
Dim vInspectionResult
vInspectionResult = Request.Form("InspPer"
Dim oRSp
Set oRSp = Server.CreateObject("ADODB.Recordset"
SQLtxt= "SELECT [Permit],[Type],[Date requested],[Date
inspected],[Assign to],[Insp trade],[Inspector],[Result],[Comments]
FROM Insp Where Permit = " & vInspectionResult & ";"
oRSp.Open SQLtxt, "DSN=Inspection"
If NOT oRSp.EOF then
oRSp.MoveFirst
Response.Write "<TABLE BORDER=1><TR>"
'Header Row
For Each oHeader in oRSp.Fields
Response.Write "<TH>" & oHeader.name & "</TH>"
Next
Response.Write "</TR><TR><TD>"
'Data Rows
Response.Write oRSp.GetString
(,,"</TD><TD>","</TD></TR><TR><TD>"
Response.Write "</TD></TR></TABLE>"
Else
Response.Write "There are no Records Matching that Permit
Number"
End If
oRSp.Close
Set oRSp = nothing
%>
</BODY>
</HTML>
Ok now I went to the Web Server and its IIS 4. I set up a System DSN for the Database which is an Access 2000 database named inspections. I selected Microsoft Access driver. Named it Inspection and pointed to the file P:\Inspections\Inspections.mdb <-- this file is on the network that is shared by us workers and the IIS server where my two ASP files are at. I set the DSN on the webserver to point to that network file. Set up just fine. I copied my two ASP files to the server. Then I opened Internet Explorer and typed the address to the first ASP success asked for a number typed one that I know is a record and clicked on submit. I get this message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/InspResult.asp, line 16
Ok I was like hmmm unknown? Then I sent a network message asking people who are using the file to close down and they did. Still same message. Here are my thoughts to explain this:
1) This is an Access 2000 files but information from Paradox was imported into the database. Now the Paradox Database is still in use while we are making this new database. Is it possible that Access is
looking at the Paradox database and treating that as the reason its saying open??
2)Do I need to have the current version of MDAC on the server? Like any known problems like certain patches upgrades.
Any help or ideas will be greatly appreciated. I have done this at home using PWS and Access 2000 and it works great but knew either lucky or not. So I am wondering if my first assumption is right or do I need to do something else to get it to work. Again Help ASAP and I thank you for your time. Have a nice day.
<HTML>
<HEAD>
<TITLE>Inspection Results</TITLE>
</HEAD>
<BODY>
<CENTER><Font Size =5><BOLD>Inspection Results</BOLD></FONT></CENTER>
<P>
<%
Dim vInspectionResult
vInspectionResult = Request.Form("InspPer"
Dim oRSp
Set oRSp = Server.CreateObject("ADODB.Recordset"
SQLtxt= "SELECT [Permit],[Type],[Date requested],[Date
inspected],[Assign to],[Insp trade],[Inspector],[Result],[Comments]
FROM Insp Where Permit = " & vInspectionResult & ";"
oRSp.Open SQLtxt, "DSN=Inspection"
If NOT oRSp.EOF then
oRSp.MoveFirst
Response.Write "<TABLE BORDER=1><TR>"
'Header Row
For Each oHeader in oRSp.Fields
Response.Write "<TH>" & oHeader.name & "</TH>"
Next
Response.Write "</TR><TR><TD>"
'Data Rows
Response.Write oRSp.GetString
(,,"</TD><TD>","</TD></TR><TR><TD>"
Response.Write "</TD></TR></TABLE>"
Else
Response.Write "There are no Records Matching that Permit
Number"
End If
oRSp.Close
Set oRSp = nothing
%>
</BODY>
</HTML>
Ok now I went to the Web Server and its IIS 4. I set up a System DSN for the Database which is an Access 2000 database named inspections. I selected Microsoft Access driver. Named it Inspection and pointed to the file P:\Inspections\Inspections.mdb <-- this file is on the network that is shared by us workers and the IIS server where my two ASP files are at. I set the DSN on the webserver to point to that network file. Set up just fine. I copied my two ASP files to the server. Then I opened Internet Explorer and typed the address to the first ASP success asked for a number typed one that I know is a record and clicked on submit. I get this message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/InspResult.asp, line 16
Ok I was like hmmm unknown? Then I sent a network message asking people who are using the file to close down and they did. Still same message. Here are my thoughts to explain this:
1) This is an Access 2000 files but information from Paradox was imported into the database. Now the Paradox Database is still in use while we are making this new database. Is it possible that Access is
looking at the Paradox database and treating that as the reason its saying open??
2)Do I need to have the current version of MDAC on the server? Like any known problems like certain patches upgrades.
Any help or ideas will be greatly appreciated. I have done this at home using PWS and Access 2000 and it works great but knew either lucky or not. So I am wondering if my first assumption is right or do I need to do something else to get it to work. Again Help ASAP and I thank you for your time. Have a nice day.