How to Update Data in a Microsoft Access Query

By updating data in a Microsoft Access query, you can change or update the data in the underlying table. These instructions are for Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Open the query in Datasheet view to edit a query based on one table, on tables with a one-to-one relationship, or tables based on a one-to-many relationship. Edit the data as required.

2. To automatically update records in a database that is shared on a network, open the query in Datasheet view. On the Tools menu, click Options, then Advanced.

3. In the Refresh Interval box, enter the number of seconds you want between each automatic update.

4. To update records in linked tables, create and run an Update Action Query.

Tips & Warnings

• Only tables linked by a Join Line can be updated from a query.
• You cannot update a query that is based on three or more tables containing many-to-one-to-many relationships.
• You cannot edit the data in a crosstab query, certain SQL pass-through queries, a query whose unique value property is set to Yes, a query including linked ODBC tables, or a paradox table without a primary key.