Connecting to SAGE

[franc sutherland]

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]

On May 15, 9:55*am, franc sutherland <[e-mail]>
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

[franc sutherland]

On May 15, 7:03 pm, timmg <[e-mail]:

On May 15, 9:55 am, franc sutherland <[e-mail]>
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.