I am having difficulty in importing records to a database which although it was created some time ago has not been brought into operation because of problems.
We are now at the stage where we would like to use it but testing has shown that there is a flaw in the importing/exporting procedures.
I feel that it is because the developer did not create a single primary key field in the subform. Instead he has created a unique record by making six separate fields part of the primary field (these are the column headings where the background is pink in the attached spreadsheet).
The yellow entries are the records that are lost;. I have also included the records close to them to show that there are many similarities but they are all different in one field or other,
I must admit that I thought that combining a number of fields into a primary key made the record unique but it doesnt seem to be working. Even moreso when you use the general date format as one of the fields where the seconds will almost always be different.
Please, please, please tell me where its gone wrong. Its too late to create a further autonumber field or suchlike because there are many hundreds of lines of VBA code that would all have to be amended and re-tested.
I really am at my wits end
Any help would be appreciated
Brian Jermain
Scotland
We are now at the stage where we would like to use it but testing has shown that there is a flaw in the importing/exporting procedures.
I feel that it is because the developer did not create a single primary key field in the subform. Instead he has created a unique record by making six separate fields part of the primary field (these are the column headings where the background is pink in the attached spreadsheet).
The yellow entries are the records that are lost;. I have also included the records close to them to show that there are many similarities but they are all different in one field or other,
I must admit that I thought that combining a number of fields into a primary key made the record unique but it doesnt seem to be working. Even moreso when you use the general date format as one of the fields where the seconds will almost always be different.
Please, please, please tell me where its gone wrong. Its too late to create a further autonumber field or suchlike because there are many hundreds of lines of VBA code that would all have to be amended and re-tested.
I really am at my wits end
Any help would be appreciated
Brian Jermain
Scotland
