trekkor77 Posted September 26, 2013 Report Share Posted September 26, 2013 If you are in query design, in the sql view, can you do "find & replace" for the text in the query itself? I've done internet searches for this and it keeps returning info about finding an replacing data in the database, which I do not want to do. The reason I need find and replace in the query text itself, is that I have copied queries from one database to another. The table structure is exactly the same, but of course, the databases have different names. What would be even better than the above is a find & replace tool which would quickly search through all your queries and change text in the queries. Quote Link to comment Share on other sites More sharing options...
ɹəuəllıʍ ʇɐb Posted September 27, 2013 Report Share Posted September 27, 2013 I have never used MS Access (I prefer MS SQL), so I don't know. But most MS tools use Ctrl+H for the replace function. If the MS Access query tool does not offer that option, use Notepad to edit these queries. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.