I am trying to make a simple login script with the names and passes stored in an Acces 2000 database. It was working fine before, but now when I go to the page I get this:

Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. 

/auth.asp, line 15
Here is the code:

VB Code:
  1. Set oConn = Server.CreateObject("ADODB.Connection")

  2. oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("logins.mdb"))

  3.  
  4. sSQL = "SELECT Name, Password FROM np"

  5. Set oRS = oConn.Execute(sSQL) ' This is line 15

The strange thing was that this was working fine a few minutes ago.