S
SFAxess
With Access 2000/2002 you can set in the options to
update any query or table name changes in dependent
objects. It works OK, but if you have a SQL string
(instead of a query or table) as a record source for a
combo box, form, report, list box etc. it will not update
those, nor will it update a reference to the field or
table in your code. Basically you have to rename
everything yourself to be sure.
Viewing queries in SQL view can make it easier, as well
as using the Find utility in the Visual Basic editor to
update your code. Pay special attention to the record
sources of your objects which may use SQL strings.
That is all I can suggest.
update any query or table name changes in dependent
objects. It works OK, but if you have a SQL string
(instead of a query or table) as a record source for a
combo box, form, report, list box etc. it will not update
those, nor will it update a reference to the field or
table in your code. Basically you have to rename
everything yourself to be sure.
Viewing queries in SQL view can make it easier, as well
as using the Find utility in the Visual Basic editor to
update your code. Pay special attention to the record
sources of your objects which may use SQL strings.
That is all I can suggest.