Hello,
Hopefully I'm near the right discussion group.
I'm trying to get started with integrating some of my manufacturing company's ACCESS databases with Microsoft's Small Business Accounting (SBA). The SDK for SBA provides plenty of VB code one I get past a certain point.
Can ACCESS be used as a front end for SBA?
Can anyone offer a sample .mdb with code that logs in to the db and adds a new customer (for example)?
TIA
rick
Definitely not the right group, Rick, as Access/VBA can not directly use ADO.NET. I don't know much about SBA, but I took a quick look, and on my system SBA stores its data in a SQL Server instance called ServerName\MICROSOFTSMLBIZ. You should, as far as I know, be able to connect to it from Access using any of the standard methods commonly used to connect to any SQL Server database, e.g. ADP, ODBC-linked tables, or programmatically via ADO 'classic' or DAO. If you haven't already done so, try asking in a forum dealing with Access ADPs or Access and ODBC. -- Brendan Reynolds Access MVP> Hello, >
> Hopefully I'm near the right discussion group. >
> I'm trying to get started with integrating some of my manufacturing
> company's ACCESS databases with Microsoft's Small Business Accounting
> (SBA). The SDK for SBA provides plenty of VB code one I get past a
> certain point. >
> Can ACCESS be used as a front end for SBA? >
> Can anyone offer a sample .mdb with code that logs in to the db and adds
> a new customer (for example)? >
> TIA > > >
> rick >
>
No comments:
Post a Comment