change field names - access 95

[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

 

[Arvin Meyer]

You might try Speed Ferret or Find & Replace:

http://www.moshannon.com/

http://www.rickworld.com/products.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

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