When you convert a file data source name (DSN) to a system DSN in the Data Access Tool (DAT), the tool makes a copy of the data source if the name already exists as a System DSN. If you convert the File DSN a third time, DAT will add the characters "()". These characters are not valid in the Data Access Tool.
↑ Back to the top
To work around this problem, rename the File DSN that you are converting to a name that does not exist as a System DSN.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
↑ Back to the top
Microsoft is researching this problem and will post more information in this article when the information becomes available.
Steps to reproduce the behavior
1. | Create a system DSN that is named Test. |
2. | Create a file DSN that is named Test. |
3. | Convert the file DSN to a system DSN, and then click Refresh. |
↑ Back to the top