Error received when trying to switch location of DB to another server using DSN file.
Posted on 2004-08-24
Hi, I have a report which uses five tables and view located on a single DB. It worked but three of the tables had no data in them. I found out that these three tables were actually on another server and that I was looking at empty copies of the tables. So, I had to change the location of these three tables so that they would pick up the data. When I tried to do this I got the following error message.
Microsoft OLE DB Service Components: The file is not a valid compound file.
This is in Cr 8.5
What I did was click Database|Set Location to get the Set Location dialog box. Then I highlighted one of the thrre tables which needs to be changed. and clicked the Set Location button. I get the Data Explorer button, navigate to the More Data Sources folder and open the OLE DB folder. Under this folder I click the "Connect Using Data Link File". This opens up a new dialog box which allows me to navigate to a specific file. I changed the file type to ODBC DSNs and navigate to the folder where several DSN files have been set up by our system administrator. He assures me that these DSNs work with MS Access as he just tested them. When I click on the DSN that refers to the table I'm trying to set the location for I get the error mentioned above. The system Admin's take on it is that CR is becoming confused and still thinks that the DSN file I'm trying to use is a UDL (User Data Link) file.