From one Access Database to another, I do SELECT * FROM query IN "C:\DB
\other\database.mdb"
This usually works well. I created a function to use in the other
database and it works great.
But now when I do SELECT * FROM query IN "C:\DB\other\database.mdb",
I get an error "Unrecognized Function"
How to get around this?
Apparently you can't do this.
So I tried, plan B, opening the purchase database and running the
function with
Dim accapp As Access.Application
Set accapp = New Access.Application
accapp.OpenCurrentDatabase "C:\DB\other\purchase\purchase.mdb"
' run a user defined function
Me.Text10 = accapp.Run("getMaterialDescription", 75) ' 75 here is a
material ID
This works but is slow.
I can bring the records into the first database from the second
database with a query and then process them, plan C.
I would rather not do that as there are three other databases that
will need to do essentially the same thing.
I just want to say "getMaterialDescription" from the purchase database
and be done.
I have also tried, plan D, a temp table in the purchase database and
then queried it and that also works, but has a number of
other disadvantages.
Looks like plan C will be the choice. unless there are better
suggestions.