Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet which refreshes from data in an Access database.
I have had to put user level security in the database & now the link to it has stopped working, it says I do not have access. I assume I have to change something in the OLE DB Query, I have tried putting the File name (including the path) after the System Database but it still does not seem to work. I have tried various passwords but nothing seems to refresh the data. There will be a few users who will need to refresh information, they all have their own passwords to access the database. Can someone please help me Thanks Sharon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel File Linked in Access | Excel Discussion (Misc queries) | |||
Excel to Access... | New Users to Excel | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |