Solved

Looking for product to refactor MS Access

Posted on 2015-02-24
4
98 Views
Last Modified: 2015-02-25
I am looking for a product that I can modify all my objects in an Microsoft Access Database 2010.  

For example I could tell it to change SS# to SocialSecurityNumber and it would go through the database and change it in forms, reports, macros, vb code etc.

I remember there was a product that I used to use back in Access2000 that did that but cant remember.

Thank You
0
Comment
Question by:charlesbaldo
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40629184
You want Rick Fisher's Find and Replace:

www.rickworld.com

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40629568
No points please.  

Agree with Jim Find & Replace is the standard.  It will search all object types, code, properties.  You can do a find only to view all of the occurances where your search string was found, and determine whether you want to update all occurances or only some.  For example, sometimes, you might want to display SSN instead of the full field name in a query used on a form or report.  If you decide you want to make all the changes, you can go back and run the find and replace and check the "Replace without asking" checkbox.  But if you find that there are some that you don't want to replace, you can leave that box unchecked and step through each find and manually select the ones you want to update.

The only thing I wish it would do, that I have not figured out (it may do this) is let you review the results of the search, mark the ones you want (or don't want) and then run the update to only update those that you want updated.
0
 

Author Closing Comment

by:charlesbaldo
ID: 40629743
Thank You
0
 
LVL 57
ID: 40630347
<<The only thing I wish it would do, that I have not figured out (it may do this) is let you review the results of the search, mark the ones you want (or don't want) and then run the update to only update those that you want updated. >>

  That's not in there, but what is in there is the cross reference utility, which I find invaluable in cleaning up DB's.   With it, you can tell what objects are used by what, or not used by anything.

Really helps me get rid of the junk when I pickup someone else's app.

Jim.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question