BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Login Register Member List
  » BaseNow Forums   » Questions   » Duplicate Records Access Datab...  

Welcome Guest ( Login or Register )


Duplicate Records Access Database
Author
Message
Posted 11/3/2005 8:48 AM
Forum Member
Forum Newbie

Group: Forum Members
Active: 11/3/2005
Posts: 1

Hi,

I have just downloaded the trial version of the software and looking to remove duplicate records, I get these error messages:-

 


--------------------------------------------------------
Gate Comm Software Database Tools 1.1 1.1.139
Error Log started at 03/11/2005 12:50:24
--------------------------------------------------------
03/11/2005 12:52:28 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The search key was not found in any record.
03/11/2005 12:52:28 - Error Number: -2147220305, Error Source: gctlRecords.RemoveRecords.ErrH, Error Description: Maximum number of errors reached.
03/11/2005 12:52:28 - Log Closed. There were 1 errors.

--------------------------------------------------------
Gate Comm Software Database Tools 1.1 1.1.139
Error Log started at 03/11/2005 12:53:29
--------------------------------------------------------
03/11/2005 12:55:07 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The search key was not found in any record.
03/11/2005 12:55:10 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
03/11/2005 12:55:10 - Log Closed. There were 2 errors.

--------------------------------------------------------
Gate Comm Software Database Tools 1.1 1.1.139
Error Log started at 03/11/2005 13:31:04
--------------------------------------------------------
03/11/2005 13:33:18 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The search key was not found in any record.
03/11/2005 13:33:21 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
03/11/2005 13:33:21 - Log Closed. There were 2 errors.

--------------------------------------------------------
Gate Comm Software Database Tools 1.1 1.1.139
Error Log started at 03/11/2005 13:34:20
--------------------------------------------------------
03/11/2005 13:35:56 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The search key was not found in any record.
03/11/2005 13:35:59 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
03/11/2005 13:35:59 - Log Closed. There were 2 errors.

--------------------------------------------------------
Gate Comm Software Database Tools 1.1 1.1.139
Error Log started at 03/11/2005 13:41:35
--------------------------------------------------------
03/11/2005 13:43:30 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The search key was not found in any record.
03/11/2005 13:43:33 - Error Number: -2147467259, Error Source: Microsoft JET Database Engine, Error Description: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
03/11/2005 13:43:33 - Log Closed. There were 2 errors.

When I check the database I can see there have been no changes, could anyone help.

 

Thanks


Ashley

IP Logged
This member is offline.
Posted 11/6/2005 1:29 AM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64
The program has experienced some problem when trying to access your database. It is possible that the database is corrupted or that the index on a specified column prevents the program from making changes.

Try to compact your database and, if possible, remove all indexes. Try also to use a different table with the different structure to see whether problem can be reproduced.

Which database format is configured in the program's object browser?
IP Logged
This member is offline.
Posted 5/11/2006 3:32 PM
Forum Member
Forum Newbie

Group: Forum Members
Active: 5/11/2006
Posts: 1

I had the same error number, after a lot... found that my table name is a reserved word.

Do not use reserved words in queries.

 

 

Servin
IP Logged
This member is offline.
Showing page 1 of 1 - 3 messages found
« Next Oldest :: Next Newest »

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.