Access Dev Tools – Find and Replace
Once a Microsoft Access application has more than a handful of queries, forms and reports it’s hard to keep track of where which object was used or where you used a certain term. Still, when doing major changes, it is crucial to find all those spots. Whether it is because you want to rename an object, or your client wants a certain term changed in all locations, searching and replacing manually is tedious and error prone work.
Save time and trouble – Let a tool do the work for you!
Access DevTools – Find and Replace will …
- … tell you where a certain object is referenced.
- … will find all occurrences of a certain term.
- … will replace any occurrence of a term.
And it will let you do all the above with an easy interface and super-fast execution.
Find and Replace finds terms in all properties of tables, queries, forms, reports, macros, and even in your VBA code. You can easily jump from one match location to the next or get all matches listed in a convenient sortable and filterable result list. It can even store the result list in a database table for future reference.
Terminology and reference changes in large databases can take hours and still have a high risk of error. With Find and Replace you can do them conveniently in seconds and without the risk.
Easy to use add-in!
Find and Replace is an add-in for all current versions of Microsoft Access. (It works in Access 2007 to Access 2019, including Office/Access-365 click-to-run installations.) You install it only once and can run it in any Access application from a custom tab in the Office Ribbon with just a click. Its multi-language user interface can be easily switched between English and German.
Fair and simple licensing
Find and Replace is licensed per user. Each developer working with Find and Replace needs a license. – That’s it!
There is no restriction on the number of computers you can use it on, there is no subscription, no time limit, no strings attached. – We might charge for future major updates, though.
No Windows Admin rights required!
You do not need any special permissions to install Find and Replace. If you can run Microsoft Access, you should have enough permissions to install Find and Replace.
A word of caution
Be sure to have a current backup before doing any large scale replace operation on your database. Better always run a plain search with the criteria before starting a replace operation. – There is no undo-option.
Download a free trial!
Try out our Find and Replace tool for yourself! – The trial version is fully functional for 30 days.
Trial Download for Access 32Bit
Version 1.2.4, Released 2023-01-22
Trial Download for Access 64Bit
Version 1.2.4 (x64), Released 2023-01-22
Windows Smart Screen Warning
When you are downloading the Find and Replace installer package, Windows Smart Screen might warn you the file might harm your device. Please note, the cause for this warning is that “this app is not commonly downloaded“. There is no real problem with this file. It is also digitally signed to ensure authenticity. Use the “Keep anyway” option to download the file.
The downloadable file is a Windows Installer setup (.msi) file. You double click the file in Windows Explorer to run it with the Windows account you use for your work in Microsoft Access. If you encounter problems with the installation or want more information about the installation and applying a purchased license, please see our detailed installation instructions.