[AccessD] Weird Problem...for me anyhow

Hi John
Have you (taken a copy first and) repaired and/or compacted the BE (or whole
thing if she doesn't have a BE/FE split)?
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] Weird Problem...for me anyhow
Date: 16/05/07 13:18


I have a user who has setup her own DB...good that she has an interest in
Access...bad that she THINKS she is capable of doing this. I have had to
bail her out before, and once again my help has been requested. OK, so maybe
I got a little chip on my shoulder w/this one ;o)

Anyhow, a fellow employee deleted some records and now there is some form of
corruption going on. I am viewing this is A2K3 and, in one of the tables
(CANDIDATES TABLE) there is a record where each of the fields says,
"#Deleted." And, in another table (EXAM LIST), which has a relationship
w/the first table, if you press the "plus sign", to the left of each
record...any record in the table...you get a pop-up saying, "Record is
Deleted."

I tried to delete the record w/the "#Deleted" contents in it, but although
you have to verify deleting one record, and it does appear to go away, if
you leave the table and reenter it, the record is back.

I was extremely busy the last two days, so I tried the quick fix of creating
a new DB and importing all the objects, but this did not work. It would not
import the table, "CANDIDATES TABLE."

I was going to recover the DB, in a working state, from a backup tape, and
just export a group of records that were recently input, out to there, but
I'm not sure I can do this either. For one thing, I don't know if I can be
sure to get all the related fields correct.

I am about to tell them, "Here is your recovered database. You will need to
re-enter the data you've lost. Sorry!" But I wanted to run it by this list
first.

Any ideas?!

John W. Clark



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2