Cursoradapter not updating base tables

For information about entering new data in a database, see the article Add one or more records to a database.

cursoradapter not updating base tables-58

You use this type of field when you want to display data from a file created in another program.

For example, you can display a text file, an Excel chart, or a Power Point slide deck in an OLE Object field.

You can enter only currency values in this type of field.

Also, you do not have to manually enter a currency symbol.

Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.

As you proceed, remember that updating data is not the same process as entering new data.

You can use the commands on the Datasheet tab, or you can open the table in Design view.

The following sets of steps explain how to use both techniques.

For more information about using rich-text formatting in a Memo field, see the article Format data in rows and columns.

Like Text fields, you can also run conversion functions against the data in a Memo field.

Large updates become much easier to perform when you understand some of the basic principles of database design.

Tags: , ,