By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,166 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,166 IT Pros & Developers. It's quick & easy.

Connecting to sage line 50

P: n/a
kj
Hi people,

newcommer here, i know a little ms programming but am new to sage,
Is it possible to connect to sage line 50 with ms access?

TIA
Keith
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"kj" <kj@hfjdsdfsa.com> wrote in message
news:d4**********@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
Hi people,

newcommer here, i know a little ms programming but am new to sage,
Is it possible to connect to sage line 50 with ms access?

TIA
Keith

You can get read-only drivers for free, but if you need to update you get a
Developer's kit from Sage. Have you taken a look at their website?
Nov 13 '05 #2

P: n/a
To read Sage Line 50 data just set up an ODBC connection using the
driver that is installed with the Line 50 program and then link to the
tables in Access (worth setting up a separate user in Sage and then
saving the password when linking the tables, also note Sage is a bit
case sensitive in some areas such as account refs, etc)

To write to Line 50 Justin is correct you need to be a Sage Line 50
Developer - this costs!! - if this is a minor part of your
requirements it may be an option to write your access database and
then have a standalone 'Post to Sage' database that shares the same
backend.mdb but is written by a Sage developer (I have done something
similar for a customer who wanted full access to his database so I
separated off the posting to Line 50 module)

Drop me an email if you need more specific details or contact the Sage
developer team for a developer in your area
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.