Creating an Object Field


graphics/04inf22.jpg

graphics/one_icon.jpg

After you've opened the table you want to change in Design view, click in the first empty row or insert a new row (shown here).

graphics/two_icon.jpg

Type a name for the field (in this example, Picture ) and press Tab .

graphics/three_icon.jpg

Click the down arrow that appears in the Data Type column and click the OLE Object option in the list that appears.

graphics/four_icon.jpg

Click the Save button to save the table design.

INTRODUCTION

In addition to storing text, numbers , and links, you can also store objects , such as pictures, worksheets, sounds, and so on, in your database. For example, you might want to include a picture of each product in a product database table. You aren't limited to pictures, however; you can include a worksheet, Word document, sounds, and other file types.

TIP

Linking OLE Objects

When you insert an object, it is embedded in the database file, separate from the original file. You can, however, set up the OLE object so that the database object is linked to the original file. To do so, click the Link check box when inserting the file. When the files are linked, if you update the original file, the file in the database table is updated as well. Consult online help for more information on linking data from other programs to an Access table.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net