My asp.net app doesn't see new records added to access 2000 database

[rambleon]

My asp.net app doesn't see new records I add to the Access 2000 table. If I open the table from the Server Explorer the new records appear. Any ideas how I can make them visible from my asp.net app. ??

 

[ca8msm]

You have given absolutely no information about how you are showing records on your page to start with, so there is very little we can help you with.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[rambleon]

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\

http://wwwroot\eltlush\elaldb.mdb;"

/>

</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.

 

[ca8msm]

Ok, there doesn't appear to be anything fundametally wrong with the way you are reading the records, so it may come down to how you are adding them or perhaps something else like page caching.

Can you show us how you add the records to the database (if there isn't too much other non related code in the page, it may be easier if you show the whole page otherwise a shortened version of all add/view functions should suffice)?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.