Access database update sage

What is sage?

Sage accountancy software

Sage is a seperate piece of s/w, you will need to find out if there is anything out there which allows you to communicate with that database, hopefully one exists for VB to use, someone may have written an OCX

Hopefully somebody here knows else you might wanna do a search on google or something

i admittedly don't know sage, and 'update' can mean a lot of things (you might want to post details about it), but i would start by investigating whether sage provides an ODBC interface and/or whether it's possible to call sage using command line parameters and/or some sort of batch file.


--bluelizard

Just had a look at the website (I think this is theirs)
http://www.sage.co.uk/partners/additions/search.asp?tid=139077&stid=139215

so it must be possible to create addons

maybe its worth contacting Sage themselves to see what SDK's they might have available

yep, there is one
http://www.sage.co.uk/partners/home.asp?tid=139104&stid=139628&pid=139709

I did a quick search on google for "Sage ODBC", and got plenty of references.  Not being familiar with the software, I would not trust myself to make a recommendation on any of the drivers I saw.  I'm sure you'll be able to locate one out there that suits your needs, and they are generally pretty simple to install.

I did the same thing awhile back with Access, AS/400, and MAS90.  It was a reconciliation routine to compare a database inventory against running bank transactions.  The project did not call for updating the internal db of the accounting software (MAS90), only drawing reports from the data, and good thing since it did not truly support external updates.