I'm new to ASP and planning on writing a real program but I've started using the tutorial on using ASP with Access Database. The program is simple, it just lists records in a database
But I get the error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/test/guestbook.asp, line 28
The code on line 28 looks like:
rsGuestbook.Open strSQL, adoCon
The preceeding lines are:
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("guestbook.mdb")
strSQL = "SELECT tblComments.Name, tblComments.Comments FROM tblComments;"
I've tried looking up this error on technet and can't find anything. Any help would be great. Thanks!
Topic Options
Post Options
Thanks(0)
