repost, hasn't been answered :) :)

[nydia]

I posted a question in the access forms newsgroup
yesterday morning and the news group has been
unavailable. I can't go passed the first page. So I am
reposting.
I have a substance abuse client database that keeps track
of clients and progress notes for each meeting they
attend. each client has a client id (autonumber). for
some reason, when i entered a progress note from client id
17, it is showing up on client id 30's progress note. It
is only happening on one particular date 04/26/05 and only
with these two clients. I went into the table to try and
delete the not and i get this error message "the search
key was not found in any record"

what could have caused this and how can i fix it? Also,
what can i do to make sure it doesnt happen again.

your help is greatly appreciated.
..

 

[jl5000]

To start try to compact and repair the database, it is possible that your
tables are damaged, next check that your form is sending the correct client
id in the master link/child link fields if you are using a subform,

 

[Dirk Goldgar]

I posted a question in the access forms newsgroup
yesterday morning and the news group has been
unavailable. I can't go passed the first page. So I am
reposting.
I have a substance abuse client database that keeps track
of clients and progress notes for each meeting they
attend. each client has a client id (autonumber). for
some reason, when i entered a progress note from client id
17, it is showing up on client id 30's progress note. It
is only happening on one particular date 04/26/05 and only
with these two clients. I went into the table to try and
delete the not and i get this error message "the search
key was not found in any record"

what could have caused this and how can i fix it? Also,
what can i do to make sure it doesnt happen again.

Hmm. You may have a corrupt index or corrupt table. Check out Tony
Toews' "Corrupt MDBs FAQ" page for a lengthy discussion of the symptoms,
causes and fixes of database corruption:

http://www.granite.ab.ca/access/corruptmdbs.htm