I have an asp page that I just want to add 3 other input forms. Those 3 forms go into an access database. This page I just want to display the totals. I declared all variables, and I CALL THOSE UP LATER IN TABLE CELLS IN ACCORDANCE WITH THE OTHER 3 ASP FORMS. Anyway I get this message.
Syntax error (missing operator) in query expression '* dcprov'.
/plants/planttotal.asp, line 33
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & "
\\test\test_data\plants\dcprov.mdb"
Conn.Open
Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open "Select * dcprov", Conn, 1, 1
What exactly is it looking for? I'm am fairly new to all of this asp.
Thanks in advance to any response.
t4p67b96
Topic Options
Post Options
Thanks(0)
