Error 3709

[Greg]

On one computer I am getting the error 3709 Search Key Not Found.
This error displays when I delete a table and then re-create it using a make
table query.
I am unsure if the error is generated when the table is deleted or created
since I cannot
duplicate the problem on any other computer.

The computer has a runtime version of Access 2002 running a program I
compiled into an MDE
with a seperate .mdb for storing data. I have tried un-installing and
re-installing the Access runtime
with no success. The computer is running Windows ME.

I have copied both the Program mde and data file to other computers and they
work fine.

Any ideas what might cause this error?

 

[Allen Browne]

To help get rid of the problem:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Another workaround might be to not delete the table and use a Make Table,
but to delete the records and use an Append query.

You can delete the records programmatically with:
dbEngine(0)(0).Execute "DELETE FROM MyTable;", dbFailOnError

 

[Greg]

Allen,

Option 1. Check the program and it had already been un-checked
Option 2. I had already done that to both the data and the program but
tried it again and no change.

Deleting and re-making the table is the most obvious place that error is
returned. I also get the same
error when I attach to a different data file or make changes to the data
file in code. The last 2 examples
I did not include earlier because I do not know exactly where in that code
the error happens.


--
Gregory M. La Due
Twin Tiers Technologies, Inc.

To help get rid of the problem:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Another workaround might be to not delete the table and use a Make Table,
but to delete the records and use an Append query.

You can delete the records programmatically with:
dbEngine(0)(0).Execute "DELETE FROM MyTable;", dbFailOnError

 

[Allen Browne]

Did you try the compact *after* deleting the table? That should help Access
get rid of it.

For a more comprehensive guide to recovering from corruption, see the first
symptom in this article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
After the import, the bad table should not be an issue any more.

The code could go into the Click event of a button it that's what you needed
to know.