Establishing a Connection
To access Access data in BizTalk, you need to configure the adapter and then configure the connection.
Configure the Access Adapter
You can configure the adapter in the properties for the receive location or send port: Select the adapter in the Type menu, and then click Configure. You can then specify receive or transmit properties in the Transport Properties dialog that is displayed.
See Adapter Configuration for guides to configure the adapter for receive locations and send ports.
Configure the Connection
After you configure the adapter, you need to configure connection properties. In the Transport Properties dialog, click the button in the Connection String box. You can set connection properties in the dialog that is displayed.
To connect to Access, set the DataSource property to the path to the Access database file.