Copy Query definition to another instance (mdb)

[nbrcrunch]

I performed a search here and searched MS-Access help but couldn't find what I need....

I need to copy queries from my mdb file to another user. How (if at all) is this done?

 

[Andrew Fergus]

Hi
I don't think it is possible to transfer the query definition to another database that is "out of sight" (someone please correct me if I am wrong). By "out of sight" I mean a database that is not on the same PC or network (if they are you can use the import function). I tried to do this the other day and failed miserably - the best I could do was to copy and paste the query SQL into a text programme such as notepad and transfer that over.

Not much of answer sorry and a pretty bad work-around too!
Andrew

 

[SydneyGeek]

You could export the query to a blank database, send that to the user, and get them to import it. I occasionally use this wen I've made a few changes and don't have the "production" version of the database with me. You can also shunt forms, modules and reports around this way.

Andrew's idea works too, as long as the user understands SQL view for pasting it back.

Denis

 

[nbrcrunch]

Thanks