D
DZ
We have moved an access db which is linked to SQL server to a new desktop.
The DSN is setup correctly and named the same as on the other machine. When
you test the DSN, it connects properly.
The access db had linked tables and reports. The linked tables did not
connect to SQL with the DSN, so we re-linked the tables. We don't want to
re-create the reports, so we need to figure out how to get the reports to
recognize the DSN on the new machine. It's set up exactly the same, but for
some reason Access does not recognize it.
The DSN is setup correctly and named the same as on the other machine. When
you test the DSN, it connects properly.
The access db had linked tables and reports. The linked tables did not
connect to SQL with the DSN, so we re-linked the tables. We don't want to
re-create the reports, so we need to figure out how to get the reports to
recognize the DSN on the new machine. It's set up exactly the same, but for
some reason Access does not recognize it.