How to Link MS ACCESS 2007 to BCM

[rickl43065]

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

 

[Luther]

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

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.