Arthur Fuller
fuller.artful at gmail.com
Wed May 16 10:08:38 CDT 2007
At first blush, I would guess that your lovely user does not know about the importance of PKs. IME, this #Deleted issue arises in only two cases, which are related: the table does not have a PK. If you're connecting to SQL Server and the table doesn't have a PK, you won't even be able to add or edit a row. If my first wag is wrong, then I would suggest experimenting with various forms of export: to Excel or Word or csv, whatever. If any of these succeed, then you can inhale the results. A. On 5/16/07, John Clark <John.Clark at niagaracounty.com> wrote: > > 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 >