Saving a query

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

Is it possible to save a query i.e. the structure and then send it to
someone else who has the same mdb file and for them to import and run the
query on their data.

Thanks in advance. Rob
 
Send them the SQL String (in a Text file) and they can construct the Query
using the SQL String.

HTH
Van T. Dinh
MVP (Access)
 
Van said:
Send them the SQL String (in a Text file) and they can construct the
Query using the SQL String.

HTH
Van T. Dinh
MVP (Access)

As first, as second export the query and the reciver, without open the file
import it.
To be sure send also the tables also without the data

--
_ _
Ciao
MAssimiliano Amendola
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
Van,

Thanks for this, got it to work albeit more fiddly than I had expected.

Thanks, Rob
 
Back
Top