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.2.00 Release date 2022-04-26
Version 1.2.0 is the recommended release of Find and Replace.
This version includes no significant new functionality and only a minor bug fix. See the list below for the changes in detail.
Feature: Restructuring of ribbon and settings UI to allow multiple plug-ins/tools in the Access DevTools add-in framework.
(Potential) bug fix: Less aggressive release of COM references to prevent interference with 3rd-party .Net add-ins when Find and Replace is unloaded.
This version includes bug fixes only. See the list below for the changes in detail.
Bug fix: When a linked table was linked with user name and password and the “Save Password” option enabled, Find and Replace was unable to find the linked table.
Version 1.1.02 is the recommended release of Find and Replace.
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.
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: 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.
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.
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
I’ve been using Find & Replace very happily for over 2 years now. It’s an essential tool and I adore it.
Sadly, the [AccDevTools] tab has recently disappeared. I have run the install again for good measure, to no avail.
I will tell you that I’ve recently inherited an old Access database that had begun implementing custom ribbons, and that included XML to hide some of the default tabs. Given that the AccDevTools tab isn’t specifically referenced, this seems unlikely to be the culprit, but I’m not that experienced with custom ribbon, so I thought it should be mentioned.
Can you please help me with some troubleshooting steps?
Also, I’m on the board of directors of DAAUG (Denver Area Access User Group), and recall your presentation for us last year, on Access performance (mainly from the Access SQL side). It was a spectacularly popular presentation, and we would be very enthusiastic about a follow-up on Access performance against SQL Server.
Dawn, thank you very much for the positive feedback!
If you had Find and Replace installed and working before, I suggest you first check in “Options” – “Add-ins” if Find and Replace (listed there as “AccDevTools.AddIn”) was disabled and you can re-enable it when selecting “Manage: COM Add-ins” + “Go…” in that dialog and simply checking it in the list.
If that doesn’t help, please check our blog post: https://accessdevtools.com/blog/microsoft-office-com-add-in-not-loading/
There are couple of other problems and solutions described.
Find and Replace – Version History
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.2.00 Release date 2022-04-26
Version 1.2.0 is the recommended release of Find and Replace.
This version includes no significant new functionality and only a minor bug fix. See the list below for the changes in detail.
Download: 32bit: FindAndReplace_ADT_1200.msi 64bit: FindAndReplace_ADT_x64_1200.msi (Download the 64bit version only if you have 64bit Access!)
Version 1.1.03 Release date 2022-01-13
This version includes bug fixes only. See the list below for the changes in detail.
Download: 32bit: FindAndReplace_ADT_1103.msi 64bit: FindAndReplace_ADT_x64_1103.msi (Download the 64bit version only if you have 64bit Access!)
Version 1.1.02 Release date 2021-03-15
Version 1.1.02 is the recommended release of Find and Replace.
This version includes bug fixes only. See the list below for the changes in detail.
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.
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.
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.
Download: 32bit: FindAndReplace_ADT_1016.msi 64bit: FindAndReplace_ADT_x64_1016.msi
Version 1.0.15 Release date 2020-02-10
Download: 32bit: FindAndReplace_ADT_1015.msi 64bit: FindAndReplace_ADT_x64_1015.msi
Version 1.0.14 Release date 2020-01-27
Download: 32bit: FindAndReplace_ADT_1014.msi 64bit: FindAndReplace_ADT_x64_1014.msi
Version 1.0.13 Release date 2020-01-22
Download: 32bit: FindAndReplace_ADT_1013.msi 64bit: FindAndReplace_ADT_x64_1013.msi
Version 1.0.12 Release date 2020-01-14
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.
2 replies to “Find and Replace – Version History”
Dawn Taylor
Hi Philipp,
I’ve been using Find & Replace very happily for over 2 years now. It’s an essential tool and I adore it.
Sadly, the [AccDevTools] tab has recently disappeared. I have run the install again for good measure, to no avail.
I will tell you that I’ve recently inherited an old Access database that had begun implementing custom ribbons, and that included XML to hide some of the default tabs. Given that the AccDevTools tab isn’t specifically referenced, this seems unlikely to be the culprit, but I’m not that experienced with custom ribbon, so I thought it should be mentioned.
Can you please help me with some troubleshooting steps?
Also, I’m on the board of directors of DAAUG (Denver Area Access User Group), and recall your presentation for us last year, on Access performance (mainly from the Access SQL side). It was a spectacularly popular presentation, and we would be very enthusiastic about a follow-up on Access performance against SQL Server.
Philipp Stiefel
Dawn, thank you very much for the positive feedback!
If you had Find and Replace installed and working before, I suggest you first check in “Options” – “Add-ins” if Find and Replace (listed there as “AccDevTools.AddIn”) was disabled and you can re-enable it when selecting “Manage: COM Add-ins” + “Go…” in that dialog and simply checking it in the list.
If that doesn’t help, please check our blog post: https://accessdevtools.com/blog/microsoft-office-com-add-in-not-loading/
There are couple of other problems and solutions described.