Using SQL Pass Through Queries in Vb/Access 1

[nissan240zx]

Hello Friends,
I want to run some SQL Pass Through queries in Access. But note although I will be storing the queries in Access I will be actually executing them from Vb as a stored procedure.

Can anyone share any thoughts that they might have encountered in a similar situation.
Anything I need to careful of, any precautions, any tips etc.

Open for suggestions. Any tutorials, example..more than welcome.
Also let me know if any further details about this task is required to answer my question..

Thanks,
Jeff Hall

 

[fredericofonseca]

There is no need for tuturials as such as all you are doing is executing some SQL on the "language" of your database of choice. So for this you should consult your database documentation.

As for ideas, they work better then Access queries as you are able to do so much more than Access can (depending on your database.)





Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[nissan240zx]

So I assume running a SQL Pass Through via a Vb Process wont be an issue.