LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default refresh data from MS Access DB not picking up changes to criteria

Hi, I hope someone can help
I have a fairly basic spreadsheet which loads data from an MS Access query.
It set up OK and if I change underlying data in the Access table, the refresh
works OK and reflects these changes. However I have had to modify the Access
query to exclude a number of records (by changing the criteria) and although
the refresh still picks up changes to the underlying data (change of name for
example) it still includes those records which should now be excluded. It is
as if the query has not been modified.

Has anyone any suggestions

Ptero




 
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
Refresh Excel Sheet with Access Data Frequently Ron[_6_] Excel Discussion (Misc queries) 0 March 1st 11 12:47 AM
Error on Refresh Data Import from Access 2+2=5? Excel Discussion (Misc queries) 0 February 4th 08 04:53 PM
Refresh Data if Access File has Password Mike H. Excel Programming 0 October 19th 07 12:33 PM
Data Refresh Issues when linking Access queries to Excel Rob Excel Discussion (Misc queries) 0 October 6th 06 06:40 PM
Ridirect & Refresh data from access database widman Excel Discussion (Misc queries) 2 March 11th 06 06:29 PM


All times are GMT +1. The time now is 03:55 PM.

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

About Us

"It's about Microsoft Excel"