T
Table colmns not found after link to DB2
I have migrated MS-Access database tables and data to DB2 where spaces in my
tables and column names have been replaced with underscores. I then create
links to these DB2 tables, delete the old MS-Access tables, and rename the
linked table to have the old name.
For example "Date Table" in Access became "CPP_DATE_TABLE" after conversion
to DB2 and I renamed it back to "DATE TABLE"
The linked table now has a column "BANK_DATE" and my queries and macros are
failing because they are looking for the old, Access, named column "Bank
Date".
Is there any tool or script that will resynchronize and update my queries,
forms, and macros to recognize the new underlying database structures?
tables and column names have been replaced with underscores. I then create
links to these DB2 tables, delete the old MS-Access tables, and rename the
linked table to have the old name.
For example "Date Table" in Access became "CPP_DATE_TABLE" after conversion
to DB2 and I renamed it back to "DATE TABLE"
The linked table now has a column "BANK_DATE" and my queries and macros are
failing because they are looking for the old, Access, named column "Bank
Date".
Is there any tool or script that will resynchronize and update my queries,
forms, and macros to recognize the new underlying database structures?