LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel File Linked in Access nukeawhale Excel Discussion (Misc queries) 1 January 21st 06 02:41 AM
Excel to Access... mseifert_99 New Users to Excel 3 January 18th 06 05:06 PM
Access Excel Linked Text and Number Issues Scott Excel Discussion (Misc queries) 2 October 4th 05 09:24 PM
Error message in Excel after exporting Access query to Excel Romi Excel Discussion (Misc queries) 0 June 6th 05 02:53 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM


All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"