MICS
asked on
Running Apped or Update Access Quesry using VisualBasic
I have 2 queries called 'Query_Append' and 'Query_Update' , these are queies made in MS Acces they are of the type APPEND and UPDATE. How can i run there queries using VisualBasic 6 code?
Thanks,
Thanks,
Have you connected to the database you want to run the queries on?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry! forgot to mention. You connect by whatever means you want. Either DSN, which I have used, or by using providers.
Madhur
Madhur
ASKER
Ok. so i tried the example above by hmadhur. and i get the error msg
"Invalid SQL statment; expected 'DELETE','INSERT','PROCEDU RE','SELEC T', or 'UPDATE'
any ideas?
"Invalid SQL statment; expected 'DELETE','INSERT','PROCEDU
any ideas?
ASKER
Ok. I fond that I was accessing teh wrong database.
ASKER
Worked Great