Search results

  1. R

    Running queries from an outside database

    How do I run queries in one database from an outside database? I've got lots of databases, each with lots of queries, that I have to run over and over. I've created a routine which runs all of the queries in one database and does other good things. (I haven't succeeded in getting it to work...
  2. R

    Closing Open Queries

    I do a lot of data scrubbing and have built a form to run a selection of queries within a database. Trouble is that I often finish with lots of select queries open at the end of the run. Sometimes I want to look at them. Sometimes I don't. How do I identify the open queries within my databse...
  3. R

    Getting all my SQL in one place

    I write hundreds of Access queries but only know a little bit of VB. What would make my life a lot easier is if I could see all a database's queries in one place, do global 'find and replaces', then replace all the queries where they came from. It's so time-consuming going into every query and...
Top Bottom