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/2024 12:50:24
--------------------------------------------------------
03/11/2024 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/2024 12:52:28 - Error Number: -2147220305, Error Source: gctlRecords.RemoveRecords.ErrH, Error Description: Maximum number of errors reached.
03/11/2024 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/2024 12:53:29
--------------------------------------------------------
03/11/2024 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/2024 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/2024 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/2024 13:31:04
--------------------------------------------------------
03/11/2024 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/2024 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/2024 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/2024 13:34:20
--------------------------------------------------------
03/11/2024 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/2024 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/2024 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/2024 13:41:35
--------------------------------------------------------
03/11/2024 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/2024 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/2024 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

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.