Solved

Looking for product to refactor MS Access

Posted on 2015-02-24
4
99 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:Charles Baldo
  • 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:Charles Baldo
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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.

679 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