We have a customer database saved in Base format that has been accumulating for about 8 years and has grown quite large. I’ve grown very accustomed to manipulating it and really don’t want to change.
We are in the process of setting our books up in Quickbooks, and would like to link it to that database so that changes in one will be reflected in the other.
I would imagine that an ODBC link would be the way to do this, but it really isn’t my wheelhouse (not that I’m afraid to roll up my sleeves and get my hands dirty figuring it out).
The ODB file lives on a Windows Server 2008 R2 file share and Quickbooks is installed on a dedicated Win7 Pro Hyper-V VM with extremely tight user, network, and internet restrictions. I’ll open up the doors that I need to in order to make the link work.
Any help is appreciated. TIA!