Connecting to SAGE

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • franc sutherland

    Connecting to SAGE

    Hi,

    I am trying to build a database in Access 2003 which can connect to
    information in a SAGE system. Should I use ODBC, and if so, which
    driver is required? Is there another way of connecting? Which is
    best?

    Thanks,

    Franc.
  • timmg

    #2
    Re: Connecting to SAGE

    On May 15, 9:55 am, franc sutherland <franc.sutherl. ..@googlemail.c om>
    wrote:
    Hi,
    >
    I am trying to build a database in Access 2003 which can connect to
    information in a SAGE system.  Should I use ODBC, and if so, which
    driver is required?  Is there another way of connecting?  Which is
    best?
    Which Sage? I've had sucess connecting to the Sage Fundraising
    products via ODBC. I think they lock down access to read only, but it
    was sufficient for the queries I needed to run. Interesting data
    model.

    I never had the need to connect directly to Peachtree - it's import
    export automation is quite sophisticated.

    Tim Mills-Groninger

    Comment

    • franc sutherland

      #3
      Re: Connecting to SAGE

      On May 15, 7:03 pm, timmg <tmillsgronin.. .@gmail.comwrot e:
      On May 15, 9:55 am, franc sutherland <franc.sutherl. ..@googlemail.c om>
      wrote:
      >
      Hi,
      >
      I am trying to build a database in Access 2003 which can connect to
      information in a SAGE system. Should I use ODBC, and if so, which
      driver is required? Is there another way of connecting? Which is
      best?
      >
      Which Sage? I've had sucess connecting to the Sage Fundraising
      products via ODBC. I think they lock down access to read only, but it
      was sufficient for the queries I needed to run. Interesting data
      model.
      >
      I never had the need to connect directly to Peachtree - it's import
      export automation is quite sophisticated.
      >
      Tim Mills-Groninger
      Hi Tim,

      Thanks for your reply. It's a basic SAGE account package like Line 50
      or Quick Accounts (or something like that).

      Where did you get the ODBC drivers from?

      Thanks,

      Franc.

      Comment

      Working...