change field names - access 95

  • Thread starter Thread starter phillip
  • Start date Start date
P

phillip

hello,

I'm working to update an old Access 95 database. I need
to change database field names and also the linked VBA-
code field names in order to link the access 95 database
with another database.

Is there an easy way to do a global field-name change that
will also change all the VBA code that references those
same field names?


thank you

phillip
 
hello,

I'm working to update an old Access 95 database. I need
to change database field names and also the linked VBA-
code field names in order to link the access 95 database
with another database.

Well... you don't, actually. Access doesn't insist that fieldnames
match in order to create queries joining tables. What kind of "link"
are you proposing which would require a name change?
Is there an easy way to do a global field-name change that
will also change all the VBA code that references those
same field names?

There's nothing builtin to Access. You can obtain some third party
tools that do this:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com
 
Back
Top