Hello,
I'm trying to automate changing a reference library from one mdb in
another. I've found a syscmd call that says it does the trick - sometimes.
My code in db1 is
dim app as Access.Application
set app = new Access.Application
app.OpenCurrentDatabase"db2.mdb")
app.Run("CheckReferences")
The CheckReferences function works fine when I run it from within db2.mdb -
and I know it fires when it runs from app because I put a msgbox in the
function just to make sure. The odd thing is that I try to step through the
code in app and into CheckReferences but it won't go "into" - only over - at
least the first time. After the line is stepped over, I'll set the
execution point back on the line and then it will step into CheckReferences
and everything will work. Wierd. I tried running CheckReferences twice
just to see what would happen, but that didn't work. I have other functions
that fire during this process that run fine. I fired app.syscmd(504, 16483)
after the call as well - no good.
Any ideas?
Thanks.
--
Matthew.Wells
Ma***********@FirstByte.net
