Excel update from Access
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
|