[AccessD] SQL Newbie Questions

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
 


 	
	



More information about the AccessD mailing list