Remotely Updating a Table

I have two tables: tblRTA3 & tblRTA4

I export them to a closed database, I then have to run this code in the database I'm working in to update them before importing them back to the database I have open:

Private Sub btnRTA3_Click()
Me.txtMsg = vbNullString
Me.txtMsg = "Updating tblRTA3 . . . Please be patient !"
Me.Repaint
Call CalcDaysBetweenOrders("tblRTA3")
Me.txtMsg = "Completed Update Successfully"
End Sub

Private Sub btnRTA4_Click()
Me.txtMsg = vbNullString
Me.txtMsg = "Updating tblRTA4 . . . Please be patient !"
Me.Repaint
Call CalcDaysBetweenOrders("tblRTA4")
Me.txtMsg = "Completed Update Successfully"
End Sub

How would I go about doing this remotely from an open database? I have come up short searching for a solution.

A great deal of thanks in advance.

-Paul

Just a question...why do you export the two tables into another database to perform some functions and then import them back into your database? Is there a reason you can't do this in the current application?

lwells

The tables are created from MakeTable queries and bloat prior to compacting and it's faster to dump them into a seperate database and compact them as the only tables in that database and then import them back in.

I don't think I completely understand what you are trying to do. Database bloat will occur when you delete a table and not compact (just one of many causes). Running a maketable query will delete the target table before creating the new table. Thus from your post are you sending the table from your maketable query to an external database, performing some sort of procedure and then importing the table?
If so, this is all good and well however if you are having to delete an existing table in your application prior to importing the table back in, then you are still going to have database bloat. If this is the case, then why even bother with using an external database? Run the queries and compile in the current application. What am I missing here?

lwells