Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help in getting external data needed please
Hi. I have a spreadsheet which links to two Access databases through System
DNS. The databases are located on my network F drive. All has been working Ok until I copied the databases to my C drive, did some work on them and then copied them back to the F drive. The databases open Ok as does the spreadsheet, but when I go to refresh the data within the spreadsheet, or to create a new database query, I see the tables and queries in the database, but then get an error message C: cannot find the file c:\filename.mdb. i have checked the ODBC connection and that clearly shows that the connection should be looking on my F drive, and the fact that I am able to see all the tables and qeruies would indicate that the connector is looking at my F drive, but why am i getting this message regarding my C drive. Any help much appreciated Thanks Alex |
#2
|
|||
|
|||
sorted thanks - someone had switched ODBC trace on and was causing problems
"Alex H" wrote in message ... Hi. I have a spreadsheet which links to two Access databases through System DNS. The databases are located on my network F drive. All has been working Ok until I copied the databases to my C drive, did some work on them and then copied them back to the F drive. The databases open Ok as does the spreadsheet, but when I go to refresh the data within the spreadsheet, or to create a new database query, I see the tables and queries in the database, but then get an error message C: cannot find the file c:\filename.mdb. i have checked the ODBC connection and that clearly shows that the connection should be looking on my F drive, and the fact that I am able to see all the tables and qeruies would indicate that the connector is looking at my F drive, but why am i getting this message regarding my C drive. Any help much appreciated Thanks Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Excel 97/2000 - Help with looking up external data. | Excel Worksheet Functions | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
parameters option on the external data toolbar is not available | Excel Discussion (Misc queries) |