Re: Error 3709
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Sat, 27 Aug 2005 00:34:26 +0800
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 - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Greg" <gml_nospam_@xxxxxxxxxxxxxxxxx> wrote in message
news:kiHPe.40360$EX.26618@xxxxxxxxxxxxxxxxxxxxxxx
> 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?
>
>
> --
> Gregory M. La Due
> Twin Tiers Technologies, Inc.
.
- Follow-Ups:
- Re: Error 3709
- From: Greg
- Re: Error 3709
- References:
- Error 3709
- From: Greg
- Error 3709
- Prev by Date: Error 3709
- Next by Date: Re: Programatically Determining What Data is used Where
- Previous by thread: Error 3709
- Next by thread: Re: Error 3709
- Index(es):
Relevant Pages
|
