General :: Need To Add Data To Read Only Database

I have read only access to a database maintained by a vendor. I am using an append query to search for new records in that database every time my database opens through a macro. This adds any new records to my table. I then add additional information to each record in my table. This is newly acquired information, not calculated, and it is different for each record.

My question is can I keep my table up to date with the vendor table without running the append query macro at open every time as my database may remain open for extended periods of time during updating of records.