Andrew Jensen wrote:
Jens: I would say then that if you want to use Base to generate some queries
for use in Access, you can. You can use the query designer as yo like, just
remember to actually turn the designer and escape processing ( by selecting
the botton 'Run SQL Direct' ) off before you save or test the query.
hello,
thanks for figuring that out! I did not find a "run sql direct" anywhere
but I think I got what you described, doing the following
- design a query in query designer view
- switch to sql view
- turn ON "Native SQL mode"
then I can save and run queries of any size
thank you
Jens
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
