Connect to Business Contact Manager data from Access 2007
| Outlook Developer Reference |
| Connect to Business Contact Manager data from Access 2007 |
To connect to Business Contact Manager data, do the following:
In Access, create a new database.
Click the External Data tab.
In the Import group, click More, and then click ODBC Database.
Click the Link to the data source by creating a linked table radio button, and then click OK.
In the Select Data Source dialog box, click the New button.
In the Create New Data Source dialog box, scroll down, click SQL Server, and then click Next.
Type a name (ensuring that the file has a .dsn extension) and the path where you want to save this connection.
Click Next, and then click Finish.
If you want to, in the Create a new data source to SQL Server dialog box, type a description of the data source and the name of the SQL server, and then click Next.
Note
The name should be the name of the server on which the Business Contact Manager database is located, followed by the instance name. For example, if the computer name is SharedBCMHost, then type SharedBCMHost\MSSMLBIZ. Note that the instance name is predetermined by Business Contact Manager for Outlook and will be the same in most cases.
Depending upon whether you are on a domain or workgroup, select one of the following authentication methods, and then click Next.
- Windows - Select this method if your computer is a member of a domain.
- SQL authentication - Select this option if your computer is a member of a workgroup.
Select the Change the default database to check box, click the name of the appropriate Business Contact Manager database, and then click Next.
Click Finish.
Verify your settings, and then click OK.
In the Select Data Source dialog box, select the data source you just created, and then click OK.
In the list of tables, do one of the following:
- To access Accounts, select the dbo.PublicAccountsView view.
- To access Business Contacts, select the dbo.PublicContactsView view.
Click OK.
In the Select Unique Record Identified dialog box, click EntryGUID, and then click OK.
In the left pane, double-click the linked table.
You can view and update Business Contact Manager for Outlook data.
We recommend against modifying the entryGUID column (because it is used internally, but you can modify other fields. Your changes will be imported into Business Contact Manager for Outlook the next time it is run (or after a short delay if it is already running).