Queries and ODBC

P

Pat Backowski

Hi Everyone,

Is there a way to invoke an MS-Access query via ODBC?

Sorry if this is in the wrong thread.....

Kind Regards,
Pat.
 
J

John W. Vinson

Hi Everyone,

Is there a way to invoke an MS-Access query via ODBC?

Sorry if this is in the wrong thread.....

Kind Regards,
Pat.
Click to expand...

Use File... Get External Data... Link; choose ODBC as files of type; select
your ODBC service.

This gives you an Access linked table upon which you can build queries to your
heart's content.

John W. Vinson [MVP]
 
P

Pat Backowski

Thanks for that, John, but I'm still a bit lost - I'm working with some 3rd
party software that allows me to do a "Free SQL" - whatever I type will be
transmitted to the jet engine - So, from an external source, via ODBC, how
can I invoke an Access query.

Thanks again, John.
Pat.
 
J

John W. Vinson

Thanks for that, John, but I'm still a bit lost - I'm working with some 3rd
party software that allows me to do a "Free SQL" - whatever I type will be
transmitted to the jet engine - So, from an external source, via ODBC, how
can I invoke an Access query.
Click to expand...

That you'll have to ask the third party software provider. I really don't
know!

John W. Vinson [MVP]
 
Top