Find and Replace – Version History

Here is an overview over the most recent releases of our Find and Replace add-in for Microsoft Access. It also includes download links if for any reason you want to download a version other than the currently recommend version from the product page.

Version 1.1.02             Release date 2021-03-15

Version 1.1.02 is currently released as a preview. – This means we haven’t done enough internal testing to make it the default release of Find and Replace. Nevertheless, we did not find any problem in our internal testing yet.

This version includes bug fixes only. See the list below for the changes in detail.

• Bug fix:Error message “COM object that has been separated from its underlying RCW cannot be used.” when searching in modules in a Access database on a mapped network share.
• Bug fix: When replacing a term in the SQL text of a query located immediately next to a line break, the first character of the line break (CR+LF) was removed. If you then replaced the new term in the same location the line break would be completely removed, potentially causing syntax errors in the query.
• Bug fix/Feature: Find and Replace now also searches in the Connect, SubdatasheetName, LinkChildFields, LinkMasterFields properties of tables.

Download:          32bit: FindAndReplace_ADT_1102.msi   64bit: FindAndReplace_ADT_x64_1102.msi (Download the 64bit version only if you have 64bit Access!)

Version 1.1.01             Release date 2020-09-17 / 2020-11-28

This version was release as preview of version 1.1 in September 2020. As of 2020-11-28 we are not aware of any significant bug in this release and recommend it for general use.

This version includes a few bug fixes and some great new features. See the list below for the changes in detail.

• Bug fix: When searching in table or query properties the property selection was ignored. (This is the bug you may have seen in my presentation of Find and Replace at the virtual Access Dev Con conference.
• Bug fix: Find and Replace now also searches in the names of modules and macros.
• Bug fix: Quoted terms in VBA code are now also found by the accelerated search.
• Bug fix: Search terms in Conditional Formatting expressions are now also found by the accelerated search.
• Feature: You can now clear the list of previous searches.
• Feature: “Look in: Active Objects” previously searched only in the top level open objects in Access. This has been enhanced to now also search through all sub forms and sub reports of the currently open objects.
• Feature: The Find and Replace result list can now be filtered with additional filter types (“Begins with…”, “Ends with..” and Regular Expressions).
• Feature: The result list now displays the number of originally found matches as well as the number of filtered results.
• Feature: You can now just hit the the [Enter] key in the search box to start searching.
• Feature: If you started searching with “Find Next” you can now escalate your search to “Find All” in the result dialog.
• Feature: You can now start by searching for a term, then filter the result list to include only a subset of the original results, and then replace your search term in those filtered results.

Download:          32bit: FindAndReplace_ADT_1101.msi   64bit: FindAndReplace_ADT_x64_1101.msi (Download the 64bit version only if you have 64bit Access!)

I published an infomercial video on the 1.1 update of our Find and Replace for Microsoft Access tool. This is an opportunity to see some of the cool new features in action without even downloading the free trial version.

Version 1.0.17             Release date 2020-04-08

New update release for general availability.

• Bug fix: While or after Find and Replace was used in a open database, Compact&Repair for that database failed with an error message (“You attempted to open a database that is already opened…”). You had to close the database to use Compact&Repair. This issue is fixed and you can use Compact&Repair without error message.
• Bug fix: Parenthesis (round brackets) were not recognized as word separators when using the “Match whole word”-option.
• Bug fix: Using the “Goto Value” command from the result list would lead to multiple selections if used multiple times for results in the same form/report.
• Feature: Find (and Replace) in linked Access tables. Find and Replace will now also find terms in the properties of linked Access tables. It can also replace in linked table properties, but this has to be explicitly enabled the settings dialog to prevent an unexpected change in behavior.

Download:          32bit: FindAndReplace_ADT_1017.msi   64bit: FindAndReplace_ADT_x64_1017.msi

---

Version 1.0.16             Release date 2020-02-15

Note: This is a hotfix release. This version is not fully tested yet and should be downloaded only if you are affected by one of the issues listed below.

• Bug fix – When closing Access while a Find and Replace dialog is open, the msaccess.exe process might hang in the background and the .laccdb lock file is not deleted.
• Bug fix – Fixed spelling mistakes in English UI texts.
• Improvement – Trial version expiry notice more obvious

Download:          32bit: FindAndReplace_ADT_1016.msi   64bit: FindAndReplace_ADT_x64_1016.msi

---

Version 1.0.15             Release date 2020-02-10

• Bug fix – Accelerated search missed some find/replace matches in reports.  
• Improvement – Clicking a Find and Replace ribbon button centers an already open dialog to “unhide” a dialog being hidden behind other windows.
• Improvement – Result List is resizable on each border

Download:          32bit: FindAndReplace_ADT_1015.msi   64bit: FindAndReplace_ADT_x64_1015.msi

---

Version 1.0.14             Release date 2020-01-27

• Bug fix – Replacing text in query SQL might cause SQL syntax error when a line break was immediately next to replaced term.
• Improvement – Several minor usability improvements.

Download:          32bit: FindAndReplace_ADT_1014.msi   64bit: FindAndReplace_ADT_x64_1014.msi

---

Version 1.0.13             Release date 2020-01-22

• Bug fix – Pasting formatted text into search or replace text boxes resulted in the text being pasted multiple times.

Download:          32bit: FindAndReplace_ADT_1013.msi   64bit: FindAndReplace_ADT_x64_1013.msi

---

Version 1.0.12             Release date 2020-01-14

• Bug fix – (64 bit only!) Find and Replace crashed when entering search criteria
• Improvement – Exclude Find and Replace search log tables from search
• Improvement – Added UI translation to French (mostly auto-translated)

Download:          32bit: FindAndReplace_ADT_1012.msi   64bit: FindAndReplace_ADT_x64_1012.msi

---

Version 1.0.11 and earlier

Version 1.0.11 and all earlier versions were only available to a limited audience of beta testers and are not listed here.