Ok. I've just started databases since this is the first time I need to use one

Can anybody tell me why this won't work:

Code:
Dim rs As New ADODB.Recordset
Dim conn As New ADODB.Connection
Dim sql As String

conn.ConnectionString = ("Provider=Microsoft.Jet.OLEDB.3.51;Data Source=D:\Visual Studio\vb98\Players.mdb")
conn.Open

sql = "Select * From First_Name"
'Raises an error: The Microsoft Jet Database engine cannot find the input
'table or query 'First_Name'. Make sure it exists and that its name is
'spelled correctly
Call rs.Open(sql, conn)
The path is correct. I'm pretty sure about the 'First_Name' bit. That's what it says on top of the column in Access' Datasheet view. I also tried it using 'FirstName' because that's what the box says in it in Access' Design View.

Also, I can't use any compenents, because when it works, I'm going to turn it into ASP (and I'll use CreateObject and all that)

I looked through my VB Book and the Tutorials on this site, but they all use some sort of control.

Any help would be appreciated,

Me.