Can i trigger a function in another database?
I want to open another database, trigger function in this database called FncCollect, then Close the remote database and then continue working im my database.Can i do this?
I think i can open the outsie database with the following code:
Dim objConn As New ADODB.Connection
objConn.Open “Provider= Microsoft.Jet.OLEDB.4.0;Data Source = c:BEFrontEnd.mdb”
now i want to trigger the function FncCollect in this database ???
But how can i give the command to run the code or the function called FncColect? And is it possible at all?
Because the function FncCollect is saved in the outside database called FrontEnd.mdb and not in the
database in which i am working.I am very curious about the answer i may receive.
-
can i trigger a function in another database? (Access 2000)
- This topic has 4 replies, 5 voices, and was last updated 23 years, 1 month ago.
AuthorViewing 2 reply threadsAuthorViewing 2 reply threads