Deleting an indexed record from table

I am trying to delete a record from a table. The record
is auto-number and indexed with no duplicates
permitted. When I try to delete the field I get the
following message "the search key was not found in any
record".

Any suggestions

Hi Bob,

Sounds like corruption whether you are using Replication or not.

Try first installing the latest version of the Microsoft JET Database
Engine, see: http://support.microsoft.com/?id=239114

Should that not change anything try Repairing your database. If you
already performed Compact/Repair and that did not resolve it then use
JETCOMP.exe, see:
http://support.microsoft.com/default...b;en-us;273956

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Bob Barry"
| Sender: "Bob Barry"
| Subject: Deleting an indexed record from table
| Date: Tue, 15 Jun 2004 14:54:15 -0700
| Lines: 7
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRTI00GmTG7YM9WRFuFcEphSUlWSQ==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:80725
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I am trying to delete a record from a table. The record
| is auto-number and indexed with no duplicates
| permitted. When I try to delete the field I get the
| following message "the search key was not found in any
| record".
|
| Any suggestions
|

Eric:

Thanks for help. I installed the update and ran the
repair progam and all is well.

Bob BArry



-----Original Message-----
Hi Bob,

Sounds like corruption whether you are using Replication
or not.

Try first installing the latest version of the Microsoft
JET Database
Engine, see: http://support.microsoft.com/?id=239114

Should that not change anything try Repairing your
database. If you
already performed Compact/Repair and that did not
resolve it then use
JETCOMP.exe, see:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;273956

I hope this helps! If you have additional questions on
this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the
patch for
Microsoft Security Bulletin MS03-026? If not Microsoft
strongly advises
you to review the information at the following link
regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/se..._bulletins/ms0
3-026.asp and/or
to visit Windows Update at
http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows
Update site will help
to insure you are current with all security patches, not
just MS03-026."

This posting is provided "AS IS" with no warranties, and
confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Bob Barry"
| Sender: "Bob Barry"
| Subject: Deleting an indexed record from table
| Date: Tue, 15 Jun 2004 14:54:15 -0700
| Lines: 7
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE
V5.50.4910.0300
| Thread-Index: AcRTI00GmTG7YM9WRFuFcEphSUlWSQ==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl
microsoft.public.access.tablesdbdesign:80725
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I am trying to delete a record from a table. The
record
| is auto-number and indexed with no duplicates
| permitted. When I try to delete the field I get the
| following message "the search key was not found in any
| record".
|
| Any suggestions
|

.