Deep Search for Access 1.1.0
Free add-in from msaccessexpert.com

Finds a word anywhere in the design of your Access database (tables, queries, forms, reports,
macros and VBA code) and can replace it. It does not search the data stored in your tables.


INSTALL (once)

1. Save DeepSearch.accda somewhere you will keep it, for example Documents.
   If Windows marked the file as blocked: right-click it > Properties > tick Unblock > OK.
2. Open any database in Microsoft Access.
3. Database Tools > Add-ins > Add-in Manager > Add New...
4. Choose DeepSearch.accda, then Close.


USE

Database Tools > Add-ins > Deep Search

1. Type a word (a field name, a table name, a word from a message) and press Enter.
2. Double-click a row, or press Open, to go to that place in design view.
3. To replace: untick any row you want to keep, type the new text in "Replace with",
   and press "Replace ticked".

A backup copy of your database is saved next to the original before anything is changed.
The name ends in _backup_ and the date and time. To undo a replace, close the database and
go back to that copy.

Close the forms, reports, tables and queries you want to change before replacing.
Rows that cannot be changed safely are skipped, and each one says why. Macro actions,
embedded macros, linked tables and relationships are shown but have to be changed by hand.

After replacing in code, choose Debug > Compile in the VBA editor to check the result.


REMOVE

Database Tools > Add-ins > Add-in Manager > select Deep Search > Uninstall.


REQUIREMENTS

Microsoft Access 2010 or later, including Microsoft 365. Tested on Microsoft 365 (64-bit).
The database must be an .accdb or .mdb you can open in design view. Compiled .accde and
.mde files have no design to search.


Questions or a database that needs more than a search: https://msaccessexpert.com/contact/
