need an analysis tool...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I am working on an Access 2000 project. Part of this project is to clean up
some of the field names etc.. as many now are not what the field name says
it is...

Many of these fields are located in modules, forms, queries, reports, macros
etc... etc.... Also in many cases they may be part of a select clause
within code or within a forms datasource property etc.. Also in dsums,
dcounts - ypou name it...

Is there any tool out there that will allow you to find every instance - not
matter where it is or in what form it's in of a particular field or for that
matter anything - a formname, report name etc.... Basically I need a search
and replace utility that does this for every Access object - not just
code...

Any help would be most appreciated!

brad
 
Is there any tool out there that will allow you to find every instance -
not
matter where it is or in what form it's in of a particular field or for
that
matter anything - a formname, report name etc.... Basically I need a
search
and replace utility that does this for every Access object - not just
code...

These folks sell LOTS of goodies for stuff like that:

http://www.fmsinc.com/Products/access.asp
 
Also look at http://www.moshannon.com/speedferret.html
This product as saved me hundreds of hours of work! but is now getting
pricy.
But if you have a major rebuild on calculate your hourly rate times the
hours you are going to spend doing it manually and then it all makes sense!

Bruce
 
There is a tool called Find and Replace for access 2000 that will help you
find where all the instances of a field are. It works great!! I think it
is available from Rick Fishers software page
http://www.rickworld.com/download.html
It is very good!

Jeff
 
Hello,

Recently, http://extremedesigners.5u.com - A website about web designing -
has been launched. I would like you to take a look at it and pass your
suggestions - complements - about it.

- Regards,
Extreme Designing Team.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top