Gary Kjos
garykjos at gmail.com
Wed May 16 09:13:31 CDT 2007
Make a copy of the database and do any and all of these things on that copy - then you can always go back to your original should something really bad happen. 1) Try Compact and repair if you haven't already. 2) there is a stand alond compact and repair called JETCOMP.EXE http://support.microsoft.com/kb/295334 Get that and run it against the database. 3) try to create a NEW TABLE using the old table as input to an APPEND query. Then if that works you could delete the old table and rename the new table to teh name the old one originally had. All I can think of. Are their any MEMO fields in this table? Memo fields are trouble sometimes. GK 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 > -- Gary Kjos garykjos at gmail.com