Error 3709 is "the search was not found"

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sue" <(E-Mail Removed)> wrote in message
news:B0A3EDA1-9F4B-4BD9-920B-(E-Mail Removed)...
> Error 3709 is "the search was not found"

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" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Sue" <(E-Mail Removed)> wrote in message
> news:B0A3EDA1-9F4B-4BD9-920B-(E-Mail Removed)...
> > Error 3709 is "the search was not found"
>
>
>

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gen" <(E-Mail Removed)> wrote in message
news:B9605D02-2EBE-4569-8D67-(E-Mail Removed)...
> 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" wrote:
>
>> 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.

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" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Gen" <(E-Mail Removed)> wrote in message
> news:B9605D02-2EBE-4569-8D67-(E-Mail Removed)...
> > 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" wrote:
> >
> >> 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.
>
>

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Gen" <(E-Mail Removed)> wrote in message
news:CC0C963F-DAA2-468D-860B-(E-Mail Removed)...
> 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" wrote:
>
>> 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.
>>
>> "Gen" <(E-Mail Removed)> wrote in message
>> news:B9605D02-2EBE-4569-8D67-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >> 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.