By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,207 Members | 1,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,207 IT Pros & Developers. It's quick & easy.

Records disappear from table

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ardith,
It is impossible to say whether records disappear -- there might be a
thousand reasons. If you can say specifically what you tried and what
the result different from what was expected, you might get a reply.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.