I have already had a CDaoRecordset TableSet using Access97 in VC++5 (WinNT). How can I execute a SQL SELECT statement in this tableset? I know that it is impossible to execute one in a tableset so can anyone guide me (in detail) on how to setup another Dynaset 'mirror' of the original tableset database so that I am able to execute SQL in?
Also, after executing a SQL statement, where can I access the extracted records data? I simply wants to display & print the result after SQL execution, how should I do it? (If possible, using Access97 to do the display & print task, but must be able to be controlled in my application.)
Thanks alot :)