Hi,
I am running Access 2000.
I have an application with a web-based front end which accesses an Access
back end using ASP (not .Net). It is being used by two groups of people -
identical web pages and database structure, just different data in the two
databases. In one of them, the first four records disappeared at one
point. In the other, one record (the same record) occasionally disappears.
There is nothing in any of the scripting that deletes anything from this
table - records get marked inactive via an attribute rather than being
deleted. The web forms and associated scripts only add new records or
change attribute values in existing records.
Can anyone offer any clues at all as to why/how these records may be
getting deleted? It is possible that the records are being deleted when a
new record is added, but the records which get deleted are not the most
recent record created. I have been wracking my brain but haven't been able
to figure it out.
Here's the code I'm using to add a new record:
qryID = "Select MAX(SSN) AS ID from tlkpEmployees"
Set rsNewID = Server.CreateObject("ADODB.RecordSet")
rsNewID.Open qryID, connTravel, 3, 3
strID = rsNewID("ID")
strID = strID + 1
' open recordset
Set rsTravelUser = Server.CreateObject("ADODB.RecordSet")
rsTravelUser.Open "tlkpEmployees", connTravel, 3, 3
'insert data into lookup table
rsTravelUser("FName") = Request.Form("FName")
rsTravelUser("LName") = Request.Form("LName")
rsTravelUser("Password") = Request.Form("Password")
rsTravelUser("SSN") = strID
rsTravelUser("Email") = Request.Form("Email")
rsTravelUser("ActNo") = Request.Form("actno")
rsTravelUser("Phone") = Request.Form("phone")
rsTravelUser("MailCode") = Request.Form("mailcode")
'ID and RecordedOn date are inserted by the database
rsTravelUser.update