I recall that it is better to use db.excute for a query than docmd.openquery.
I am struggling with the following, the same query works when I run it with DOcmd, but does not work with db.execute:
DoCmd.OpenQuery "mltc1bp2", , acEdit (THIS WOKRS)
CurrentDb.Execute "mltc1bp2" (THIS DOES NOT WORK)
also tried
set DB=currentdb()
DB.execute and it does not work either.
However I have other queries that work fine with db.execute,.
What might be the reason?.
Sarah
__._,_.___
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar