 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / February 2007Query-query dependancies
Hi! I have a lot of queries that are based on other queries, which are based on some other queries, etc... Quite a mess! I would like to simplify SQL of the top queries so that they are based only on tables, not other queries. It would be too complicated and time-consuming to do it manually, so I'm wondering if there is some commercial or free tool that can make it automatically? It would save me lot of time and nerves... I suppose that Access do something like that internally, right? Thanks, Zlatko Take a look at Rick Fisher's "Find and Replace". You can download it here: http://www.rickworld.com/download.html. If you pay the reasonable registration fee, you get added functionality that's well worth it.  Signature--Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L > Hi! > I have a lot of queries that are based on other queries, which are based [quoted text clipped - 9 lines] > > Zlatko >Hi! >I have a lot of queries that are based on other queries, which are based on [quoted text clipped - 8 lines] > >Zlatko Well, BACK UP YOUR DATABASE before you even think about doing such changes... and then I'd recommend one of these tools. Speed Ferret is my favorite. Freeware: http://www3.bc.sympatico.ca/starthere/findandreplace Find and Replace: http://www.rickworld.com Speed Ferret: http://www.moshannon.com Total Access Analyzer: http://www.fmsinc.com John W. Vinson [MVP] Thanks for sugestions, but I need some tool that automatically translates query with subqueries into plain query with tables... Best regards, Zlatko "John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> je napisao u poruci interesnoj grupi:bd19u215umfh2evr619j059lbqs3cuutho@4ax.com... >>Hi! >>I have a lot of queries that are based on other queries, which are based [quoted text clipped - 23 lines] > > John W. Vinson [MVP] >Thanks for sugestions, but I need some tool that automatically translates >query with subqueries into plain query with tables... Good luck. That sounds like a nightmarishly difficult text-parsing project. John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.