Hi all,
I'm working in an Access 97 DB that uses custom Import/Export Specifications defined in MSysImExSpecs. On quite a few of the databases I've noticed that the Spec_Id field in this table does not match the Spec_Id field within MSysImExColumns, yet import/export using this spec still functions in some cases and fails in others.
My question is this: When you create a custom Import/Export Specification using the advanced options screen and identify the import/export fields/types should it not create a record in both MSysImExSpecs and multiple records in MSysImExColumns with identical Spec_Id and the field names that you specified? That was my take on it but it appears that this specification still functions in some cases without any MSysImExColumns records. Also, uses delimiters other than the normal default so it doesn't appear to be using that instead.
If I do require Spec_Id to be the same then I guess my option is to re-create the custom spec. If I imported the corresponding data table into a blank database and then recreated the custom spec would it solve the problem by deleting those two system tables from the other databases and importing these new ones?
Any help would be greatly appreciated, there is very little info on custom specs or these two system tables anywhere.
Thanks,
Whagar [sig][/sig]
I'm working in an Access 97 DB that uses custom Import/Export Specifications defined in MSysImExSpecs. On quite a few of the databases I've noticed that the Spec_Id field in this table does not match the Spec_Id field within MSysImExColumns, yet import/export using this spec still functions in some cases and fails in others.
My question is this: When you create a custom Import/Export Specification using the advanced options screen and identify the import/export fields/types should it not create a record in both MSysImExSpecs and multiple records in MSysImExColumns with identical Spec_Id and the field names that you specified? That was my take on it but it appears that this specification still functions in some cases without any MSysImExColumns records. Also, uses delimiters other than the normal default so it doesn't appear to be using that instead.
If I do require Spec_Id to be the same then I guess my option is to re-create the custom spec. If I imported the corresponding data table into a blank database and then recreated the custom spec would it solve the problem by deleting those two system tables from the other databases and importing these new ones?
Any help would be greatly appreciated, there is very little info on custom specs or these two system tables anywhere.
Thanks,
Whagar [sig][/sig]