I'm trying to recieve values from an access database, and this is the error message i get :
Response object error 'ASP 0185 : 8002000e'
Missing Default Property
/woodya/PicRate.asp, line 0
A default property was not found for the object.
I've tried alot to fix it, can't figure it out, but her is the code :
<%
dim conn, lpicid, lpicrate, lpicavg, filepath, rspic
set conn = Server.CreateObject("ADODB.Connection")
filepath = Server.MapPath("/woodya/db/LDBPIC.mdb")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & FilePath & ";"
lpicid = conn.execute ("SELECT lphotoid FROM tbllastpic WHERE id = 99")
lpicrate = conn.execute ("SELECT lphotorate FROM tbllastpic WHERE id = 99")
lpicavg = conn.execute ("SELECT lphotoavg FROM tbllastpic WHERE id = 99")
%>
Any help, would be great, thanks in advance.