Results 1 to 2 of 2

Creating a dynamic link to a Business Objects report

  1. #1
    Remster is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010

    Creating a dynamic link to a Business Objects report

    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.)

  2. #2
    Older Fella is offline Novice
    Windows 10 Access 2003
    Join Date
    Nov 2018
    When working with multiple sources I have a practice of working out how to do it manually.

    In this instance can I get the Business Objects report into Excel and then import it into Access...for example.

    Once I get this working and can get the output I am after, then I automate the process.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating Business Cards in Access
    By JoeM in forum Reports
    Replies: 4
    Last Post: 10-26-2016, 06:12 PM
  2. Creating double-sided business cards
    By plc in forum Access
    Replies: 2
    Last Post: 07-19-2016, 06:17 AM
  3. Replies: 3
    Last Post: 05-21-2015, 06:02 AM
  4. creating a dynamic agenda in a report
    By danaraincloud in forum Reports
    Replies: 2
    Last Post: 10-09-2014, 12:49 PM
  5. Replies: 3
    Last Post: 09-05-2014, 02:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums