I can't delete a certain record in an access file. Error 3709?

[Guest]

Error 3709 is "the search was not found"

 

[Allen Browne]

Hi Sue

The solution will probably be to create a new table, and import all the
*other* records into that table.

Details in
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html
The technique is explained in the 3rd symptom.

 

[Guest]

Hello, I am experiencing the same problem - one record has turned into
chinese characters and I cannot delete it. It happend after I had two forms
opened at the same time and tried to edit the same record on either form (BIG
mistake apparently). My database is large and complex, is there any other
solution for getting rid of this record besides creating a whole new database?

 

[Allen Browne]

Creating a new *table* is not as involved as creating a new database.

Not that it's difficult to get Access to recreate the whole thing. It's a
single operation to import everything.

 

[Guest]

Thank-you for clarifying, I was thinking whole database. Yes it is easy to
create a new table and import the desired records, the tricky thing (it
seems) is now redirecting all my queries, forms and records to the new table.
Is this also easier than I think? Please give me some pointers.

 

[Allen Browne]

I don't see a need to do that.

The queries, forms, reports etc usually use the tables/queries in the
current database. Therefore no changes are required if you recreate the
database.

If you have linked tables from other databases, the other databases still
exist, so again there's nothing to do.

If this database is linked by other databases, you can rename your old one,
and name the recreated database with the same name the old one used to have.

And if none of that solves your problem, you must have linking between
database files that I did not envision, so you probably want to use the
linked table manager.