MS Access Queries

[Nick]

I know that you can execute a SQL stored procedure in the Command object but
can you do the same for a query sored in an MS Access database?

Regards
Nick

 

[Mark Rae]

I know that you can execute a SQL stored procedure in the Command object
but can you do the same for a query stored in an MS Access database?

Yup - easy as pie!

http://www.dotnet247.com/247reference/msgs/34/174771.aspx

 

[Robbe Morris [C# MVP]]

You can also use this code generator for Microsoft Access
to write the .NET code for you:

http://www.eggheadcafe.com/articles/microsoftaccess_source_code_generator.asp

 

[Nick]

Thanks Mark that's great.

Nick

Yup - easy as pie!

http://www.dotnet247.com/247reference/msgs/34/174771.aspx

 

[Nick]

Just tried it and it works a treat..

Thanks again.