Connect to Access 2002 on local computer

Steve · Apr 11, 2004

Here's the code I'm trying to use; basic ASP code and it just reads the
records in the database: I want to use it on my local computer where this
file "ReadRecords.asp" and the "calgarywebconcepts_Master.mdb" file are both
in the Inventory directory. I'm using Access 2002 and my problem seems to be
in how I'm trying to connect to the database (the first 13 lines). Can
anyone see a problem with this?

I connect very well on my website using:
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "calgarywebconcepts_Master"

set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Inventory", conn, adOpenStatic, adLockOptimistic, adCmdTable

BUT... I want to set up a database on my local computer and use some of my
asp files (through frontpage).

Thanks... Steve


<%
dim strconn
dim rs
dim conn
strconn="Provider=Microsoft.Het.OLEBD.3.51; Data
Source=C:\Inventory\calgarywebconcepts_Master.mdb"

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "strconn"

set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Inventory", conn, adOpenStatic, adLockOptimistic, adCmdTable

Response.Write "<TABLE BORDER=""1"" CELLSPACING=""2"" CELLPADDING=""2"">" &
vbCrLf
Response.Write vbTab & "<TR>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Department</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>ItemNo</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>ItemName</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Description</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Price</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Quantity</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>DateAdded</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>DateSold</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>DateTransferred</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>DateReturned</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>PictureSmall</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>PictureLarge</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Color</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Size</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Special</TD>" & vbCrLf
Response.Write vbTab & vbTab & "<TD>Discount</TD>" & vbCrLf

Response.Write vbTab & "</TR>" & vbCrLf
If Not rs.EOF Then
rs.MoveFirst
'Show data
Do While Not rs.EOF
Response.Write vbTab & "<TR>" & vbCrLf
For I = 0 To rs.Fields.Count - 1
Response.Write vbTab & vbTab & "<TD>" & rs.Fields(I) & "</TD>" & vbCrLf
Next
Response.Write vbTab & "</TR>" & vbCrLf
rs.MoveNext
Loop
End If
Response.Write "</TABLE>" & vbCrLf

rs.Close
set rs=nothing 'Close Recordset Object
conn.Close
Set conn=Nothing 'Delete connection Object
%>
<html>

<head>
<title>ReadRecords.asp</title>
</head>

<body BACKGROUND="images/bkg_white.jpg">
</body>
</html>

Ray at · Apr 11, 2004

http://www.aspfaq.com/5003

Ray at home

Steve · Apr 12, 2004

I've since changed my connection code to:

<%
dim strconn
dim rs
dim conn
strconn="Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\Inventory\calgarywebconcepts.mdb;"
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "strconn"

set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Inventory", conn, adOpenStatic, adLockOptimistic, adCmdTable

But still with no results... And there are no error messages. Do you see
anything wrong with the changes?
Thanks... Steve

Roland Hall · Apr 13, 2004

in message : I've since changed my connection code to:


Steve...

Please do not multipost.
Please follow up in original thread in m.p.scripting.asp.db

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

ASP Amphasand, XML	6	Jul 19, 2006
Error removing last vbCrLf character from a text file created by FSO CreateTextFile	4	Feb 15, 2006
ASP + Format Dates from Database	0	Dec 21, 2003
XML, asp amphasand	4	Jul 19, 2006
ASP - array sorteren (question in dutch)	1	Jun 30, 2009
What is the problem actually?	1	Mar 28, 2007
Dynamically add posted form items into array	1	Dec 14, 2005
Inserting Random Passwords into Database	14	Dec 4, 2003

Connect to Access 2002 on local computer

Steve

Ray at

Steve

Roland Hall

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads