Solved

Looking for product to refactor MS Access

Posted on 2015-02-24
4
91 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
Comment Utility
You want Rick Fisher's Find and Replace:

www.rickworld.com

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
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
Comment Utility
Thank You
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now