I need to be able to execute an Access query from my VB6 application.
will not be installed on the end user machine but the query will
in the .mdb file.
There is a reason why I need to do this as opposed to running an SQL
in VB6 but I don't want to steer this post away from my initial
question so I'll
leave out the reason..
Anyway, it seems that this can be possible because if you use the ADO
to connect to an Access database, it shows the Query's as "Stored
I just don't know how to go about actually executing a query..
The query will not return any data, it is strictly an "action" query
(such as Append,
Make table, etc..) so I don't need to show the results of the query...
Remember again that Access will not be installed so I don't want to use
any Access objects
in my code..
Sent via Deja.com http://www.deja.com/
Before you buy.