Sorry you're quite right.
Here is the function I use to read the records:
Function Authenticate(ByVal strUserID As String, ByVal strPword As String) As Boolean
Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("DSN"))
Dim objCmd As OleDbCommand
Dim objDR As OleDbDataReader
Dim userFound As Boolean
objCmd = New OleDbCommand("Select * From tblUser Where " & _
"tblUser.U_ID = " & CLng(strUserID) & " AND tblUser.U_PassWord = '" & strPword & "'", objConn)
objConn.Open()
objDR = objCmd.ExecuteReader()
userFound = objDR.Read()
objDR.Close()
objConn.Close()
Return userFound
End Function
This is the config.web:
<configuration>
<appSettings>
<add key="DSN" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\
/>
</appSettings>
It's for a login page where I check the the ID number and password against records in an Access table. The records I added before connecting the database to the web site via IIS are visible, those that I add now are not even though I can see them using in the Server Explorer.