Would it be possible for the validation to occur when the entry is made in the database program if the programmer who developed it had an export of the GL chart of accounts in a (regularly-updated) file?

You could export the fields required from Adagio Ledger whenever new accounts were added, likely in CSV format.