Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello:
I have a large report that has 104 imported external data links. These links refer to 104 differnt Access queries for a file located on a shared file server. If I click on each link individually and select "Refresh Data" from the data menu, no problem. But if I click on the "Refresh All" button on the External Data tool bar I run into some problems. After a second or two of "Connecting to data source" appears in my lower left window, I receive an "Unspecified Error" error. When I click OK I get the following window: Data file: "xyz" not found. Connect to "xyz" instead? (yes, the exact same file name.) When I click on "Yes", I'm taken to the following window: Data Links Property. When I click on "Test Connection" it fails. Any suggestions? Is there something about using a file on a server I need to be careful about? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
incorporating live data from external source to work book | Excel Discussion (Misc queries) | |||
change directory for refresh data | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
populating data from excel into access | Links and Linking in Excel | |||
Data population between excel and access - Errors on missed fields | Excel Discussion (Misc queries) |