T
TheScullster
Hi all
Has anyone had dealings with Microsoft Great Plains software running on SQL
Server and, more importantly, forged links between this and Access?
The history:
A few years back, and with much help from this group I hasten to add, I
created a database for drawing control.
This was then incorporated (by a developer employed on a temporary basis no
longer in UK) into a more complex application, which included customer info,
project data, costings etc. So now we have links to tables etc which relate
drawings to customers and such like.
The problem is:
We are now adopting the Great Plains software which will include the
customer data, project costs etc. (so this will no longer be entered into
our Access database).
So I am hoping that it will be possible to "cut down" our access database
back to drawing control only and link across to the Great Plains data for
all customer/project data.
Has anyone in the group any experience of Great Plains and linking thereto?
Can they give me a starting point?
If we were to outsource this linking/re-structuring of our existing data
base, where is our best (and cheapest) option to be had?
TIA
Phil
Has anyone had dealings with Microsoft Great Plains software running on SQL
Server and, more importantly, forged links between this and Access?
The history:
A few years back, and with much help from this group I hasten to add, I
created a database for drawing control.
This was then incorporated (by a developer employed on a temporary basis no
longer in UK) into a more complex application, which included customer info,
project data, costings etc. So now we have links to tables etc which relate
drawings to customers and such like.
The problem is:
We are now adopting the Great Plains software which will include the
customer data, project costs etc. (so this will no longer be entered into
our Access database).
So I am hoping that it will be possible to "cut down" our access database
back to drawing control only and link across to the Great Plains data for
all customer/project data.
Has anyone in the group any experience of Great Plains and linking thereto?
Can they give me a starting point?
If we were to outsource this linking/re-structuring of our existing data
base, where is our best (and cheapest) option to be had?
TIA
Phil