My organisation's HR system is hosted, and we're not allowed an ODBC connection to the database. Instead, we have a facility for creating Business Objects reports using an admin account.
My challenge is that I'm creating an Access database that needs to keep abreast of changes to data in the HR system. Is there any way of creating a dynamic link between an Access database and a Business Objects report? (A tolerable workaround might be to import data from Business Objects into a static table in Access on opening the database.)