How to Link MS ACCESS 2007 to BCM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rickl43065 - 16 May 2008 22:17 GMT

Please HELP.

I am intersted in using MS ACCESS 2007 to write a few simple oppoprtunuity
reports that are not available in BCM integrated with Outlook 2007.

I haven't a clue how to set up SQL Server to access the data within Access
2007, but have had moderate experience writing Access 2000 programs.

I have "found" the files but havent a clue how to link.

Any assistance would be greatly appreciated.

I thank you in advance.

Rick

Reply to this Message

Luther - 20 May 2008 00:14 GMT

On May 16, 2:17 pm, rickl43065 <rickl43...@discussions.microsoft.com>
wrote:

> Please HELP.
>
[quoted text clipped - 11 lines]
>
> Rick

The user connecting to the database must be a BCM shared user of that
database. If they are, then Access run from their login will have
permission to connect to the database. You don't need to change
anything in sql server.

To connect Access to sql server database, you will connect via ODBC to
the BCM sql instance and database. I think that connection info can be
saved as a file, but you don't need a file to refer to a file to make
the connection. The BCM SDK may have additional information or
examples about connecting to BCM from Access.

Reply to this Message