| Article ID: | SFKB0008 |
| Last Reviewed: | July 25, 2002 |
| Applies To: | SPEED Ferret 1.0 (SPEED Ferret for Access 2) SPEED Ferret 2.0 (SPEED Ferret for Access 95) SPEED Ferret 3.0 (SPEED Ferret for Access 97/VB5) SPEED Ferret 4.0 SPEED Ferret 4.1 |
Question
I've got a table with a field called "Priority", and about 20 queries based on that table. Can I use SPEED Ferret to remove that field from the table and all the queries based on it?
Answer
SPEED Ferret can make this job a lot easier, but not totally automatic.
Suggested Technique:
- Open the table in design view and delete the field.
- Use SPEED Ferret to search all queries for the field's name.
- For each reference that is listed in the search results, edit the New Value to remove the field name and any surrounding punctuation characters. If the field name is used within an expression (e.g. "[Priority] + 3"), you may need to restructure or remove the entire expression.
- Click the Save Replacements button to save your changes.
Summary
SPEED Ferret makes this task easier in two ways:
- SPEED Ferret quickly shows you every place the field is referenced, saving you lots of time and preventing you from missing any occurrences.
- As you edit each replacement value, each occurrence of the field name is highlighted in the Cell Editor. If a query's SQL statement contains multiple references to the field, each of them will be highlighted. This helps you to edit them more quickly and prevents you from overlooking any of them.