| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing Excel worksheet with data linked from Access
I have an Excel file with data on it that has been imported using MS Query
from an Access database. If the database is open and has been edited and saved and not closed, when I try to refresh the Excel file I get the message: ODBC Microsoft Access Driver Login Failed The database has been placed in a state by user 'Admin' on machine 'DKHWKS567' that prevents it from being opened or locked. And then I am asked to enter a password or cancel. If I close the Access file or just close the form in Access that was edited I can now refresh the data in Excel. Is there a way of Excel always being able to refresh the linked data without this happening? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refreshing linked workbooks | Excel Worksheet Functions | |||
| Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
| New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
| Excel-rolling data linked to chart/ worksheet columns keep constan | Charts and Charting in Excel | |||
| Refreshing Access data in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
