Syntax error (missing operator) in query

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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