This database is where the data is being sent, also called the target. Either the primary or secondary database can be the source or destination, depending on whether you use the transfer from or transfer to command.
The following figure shows the access service configured to access a particular primary database. The secondary database is an Adaptive Server database located on the LAN. The client application can transfer data from the primary database to Adaptive Server, or from Adaptive Server to the primary database.
Figure 8-1: Access service data transfer between databases.
During a transfer:
Data flows from a table in the source database, through DirectConnect, to the target database. Although the client application initiates the transfer, the data does not flow through it.
The DirectConnect server becomes a client to the secondary database.