Global Changes to MS Access Database

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.
 
C

Chris Nebinger

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
 
V

Vickie

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.
 
V

Vickie

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
 
L

Larry Linson

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
 

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

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to change Pivot Table external data source (MS Access Database)by VBA 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Changing Access Database without Changing Prior Info 0
Office 365 for Business vs Office Home - 'Save to' & Other Questions 0
Using Microsoft Access as a Service Ticket Write-up program 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
I need to distribute my access database 6

Top