Use Access to supplement BCM?

[Guest]

Okay, I'd still like to be able to use BCM. So here's a possibility: Can I
use MS-Access to do customized things like mail a form-letter or translate a
birthday into an age quickly? If it's on a SQL server, can't access somehow
do queries on the data? Please help me find this data, and how to connect to
it.

Thanks!

Together, we'll find a way to make BCM work for us.

 

[Luther]

If a user has permission to use a BCM database from Outlook/BCM, then
that same user can access the SQL Server database from Access or any
other tool that can connect to SQL Server.

I believe that with Access you first have to set up a Data Source that
pints to the BCM database on SQL Server; Access has a wizard to do this
(?).

If there's no wizard in your tool, you can still set up a data source
from Control Panel|Administrative Tools|Data Sources (ODBC).

The easiest way to get at the BCM data is through the Views, instead of
using the tables directly. I would hesitate to update the data directly
in the database, but there shouldn't be any reason not to do queries.