A Way to Change a Name Throughout a Microsoft Access Database
Changing a name or any other piece of data from one entry to another is a fairly simple operation in an Access database. Use the SQL "Update" query to perform the change. You need to know the name of the table and field that contains the name you want to change and the exact spelling of the name before and after the change.
Other People Are Reading
Instructions
-
-
1
Open Access and the database that contains the name you want to change. Click on "Queries" in the "Objects" menu on the left. Click on "Design," and then click "Close" to close the "Show Table" window. This type of query is much easier to type manually than through a wizard.
-
2
Click on "View" on the menu bar, and then "SQL View" to bring up a query text box. Type your query in the following format:
Update TableName set FieldName = "New Name" where name = "Old Name"
Substitute the real table name, field name, new name and old name with the actual values.
-
-
3
Click on the red exclamation point on the toolbar to run the query. You have now changed the name in all records from the old name to the new name.
-
1
Tips & Warnings
This same query will work in any database that is SQL (Structured Query Language) compliant, including all versions of Microsoft Access and SQL Server.
It is highly recommended that you run a "Select" query before running an "Update" command. This will ensure that you are changing only the records you intend to change. To do this for the above example, you would enter:
Select FieldName from TableName where FieldName = "OldName"
