Automation w/ Access

[TD]

Hello all, I'm new to VBA and trying to call a function in a remote db from
a db. This is actually working, however when I try to get any return results
from the 2nd db into the first db it just gives me an error 424 object
required. Can anyone point me to an example, or docs on how to get this to
work?

Thanks in advance.
Function MyCalltoremoteDB()
Static Object As Access.Application
Set Object = New Access.Application
Object .OpenCurrentDatabase (C:\whatever)
Object .Run("remoteFunction
'this will actually run the remote function. I've taken out any close or
quit code in the remote function to see if that was the problem. Didn't
change a thing. The remote function does what it's supposed to do then focus
is back on db1 and I get an error 424 object required.
Exit Function

 

[TC]

I suggest you cut & pate the exact code that you are running. What you have
posted, is not what you are running.

HTH,
TC