View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sharon A
 
Posts: n/a
Default 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