JParente
asked on
Insert Queries
Hi,
Is it possible in Vb6 create or update a query in MSACCESS?
If yes, how do i do that?
To insert rows in a table we use "INSERT INTO ...." is something like this for query?
Best Regards
Jorge
Is it possible in Vb6 create or update a query in MSACCESS?
If yes, how do i do that?
To insert rows in a table we use "INSERT INTO ...." is something like this for query?
Best Regards
Jorge
Jorge,
Add a querydef object to the database (querydefs collection) with whatever SQL you want. There are examples of doing this in the online help.
You can use either the ADO or DAO engine to do this, depending on your version of Access.
Add a querydef object to the database (querydefs collection) with whatever SQL you want. There are examples of doing this in the online help.
You can use either the ADO or DAO engine to do this, depending on your version of Access.
To execute a Query, try:
myADOConn.Execute myQuery
or
myDAO.Execute myQuery
myADOConn.Execute myQuery
or
myDAO.Execute myQuery
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi JParente,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept mdougan's comment(s) as an answer.
JParente, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept mdougan's comment(s) as an answer.
JParente, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
per recommendation
SpideyMod
Community Support Moderator @Experts Exchange
SpideyMod
Community Support Moderator @Experts Exchange
Anthony