Beginning Access™ 2007 VBA

A.7. Chapter 7

1. Linking stores only a pointer to the location of the underlying data source, and updates are made to the original data itself. Linking is a good idea when the data resides on a database server that your application and others can use, the data is used by another program that requires the native file format, or the underlying data needs to be updated on a regular basis in its native format. Importing data actually brings a copy of the data into your Access database. Reasons for importing data include moving an existing system that is being migrated to a new application, and having numerous data operations that need to be run against the data from another source in a speedy fashion when you do not need to change that data.

2. TransferDatabase allows you to import, export, and link to various types of databases, such as Access and SQL Server. You specify various parameters to indicate which type of action should be performed. TransferSQLDatabase transfers the entire contents of a particular SQL Server database to your application.

3. You can use the SendObject method to generate an e-mail programmatically using VBA. This method allows you to generate an e-mail with or without attachments. You can use this method to create just one e-mail, or multiple e-mails, such as for a mailing list.