Global Changes to MS Access Database

  • Thread starter Thread starter Vickie
  • Start date Start date
V

Vickie

A change in medical terminology requires that I make a
change in nomenclature to all objects and variables in my
Access 97 database in which it is used. One product,
SpeedFerret, was suggested, however, I would like to know
what experience others have had with it and if there are
other products that may be better. Thank you very much for
your input.
 
I cannot imagine what change in "medical terminology" could possibly
require you to rename all the objects in your database, and I can
imagine all sorts of problems arising if you have anything resembling
a complex database and you try to automate this. The names attached to
database objects should be mnemonic of what they are and do, of
course, but they should otherwise be arbitrary labels. Would you like
to explain further?


A change in medical terminology requires that I make a
change in nomenclature to all objects and variables in my
Access 97 database in which it is used. One product,
SpeedFerret, was suggested, however, I would like to know
what experience others have had with it and if there are
other products that may be better. Thank you very much for
your input.
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
I agree with Peter. Simply change the forms and reports,
but leave objects and variables set.

On a side note, SpeedFerret is a great tool to do this. I
highly recommend it, and I am not affiliated with the
company at all. I will recommend that you make backups
prior to running SpeedFerret.


Chris Nebinger
 
Thank you for your responses. Yes, I can see that I need
to clarify that intended changes are only to all objects
and variables that have the specific nomenclature in
question. Thank you, again. I will definitely consider
your input.
 
We may be misunderstanding each other. To an Access programmer, the
term "objects" refers to tables, queries, fields, report formats, and
the like, while "variables" are used in VBA code to hold data while it
is being modified or manipulated. It would be (to put it mildly) very
unusual to have to make wholesale changes to the names of these.

You may simply be talking about changing the values of data items in
records within tables in the database - in the sort of situation you
imply, this would generally be done by using appropriately designed
update queries to change all occurrences of "Old Name" to "New Name"
in affected records.


Thank you for your responses. Yes, I can see that I need
to clarify that intended changes are only to all objects
and variables that have the specific nomenclature in
question. Thank you, again. I will definitely consider
your input.
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Hi Peter,

Actually, I anticipate making changes to some queries,
forms and reports, etc.(objects)and only possibly to some
variable names in the code. Sorry my attempt to be
succinct was confusing. Thank you very much for your help!

Vickie
 
I have used Speed Ferret, in the Access 2.0 and Access 97 environments, and
found it to be solid, stable, and, AFAICT, it never missed a reference to
the string for which I was searching (a competing product did, in its Access
2.0 version). It found the instances, and listed them so you could
approve/disapprove of changing the specific instance. Without it, Y2K
remediation and certification of a huge Access client application would have
been much more costly.

I can see that some changes to terminology would be well-handled by changing
their occurence in Objects and Properties, so some future maintainer of the
DB would not be confused as to what they were dealing with. If your DB is
like most I encounter, the names of objects and variables are the primary
documentation!

Larry Linson
Microsoft Access MVP
 
Back
Top