Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Mar 16 00:10:34 CDT 2007
Dear List: I have a need to interface an Access app to either or both of Microsoft Small Business Accounting 2007 and Microsoft Small Business Financials packages. Their tech support tells me that they both have SQL back ends. What I would like to do is push shipping and receiving transactions from the Access app into the accounting package to trigger invoices and payables, and extract customer order detail from the accounting system into the Access app. I have ordered the 60 day trial of SBF with the SDK (which they told me is mostly a data dictionary, but that's OK). I have the SBA 2007 and in a folder there is a file named sampleproductcompany.db which I think they said is the database. There's also one named sampleproductcompany.lg. Is this a SQL database file? Can I connect to this SQL back end and if so how? MMTIA, Rocky