Hi, Gurus,
I just began to take over a new Access 2000 project from a db developer who left our company. The CEO of my company don’t like the table names and some of the primary key settings and wanted me to change them once in all. I can’t figure out how a good way to do this.
Here is what I’d like to do:
1.)Change one table name and all forms, querys, reports, macros, modules in the who Access 2000 database should reference to this new table name automatically.
2.)to change the primary key in one table should also automatimally change the foreign key in another table
I wonder if this is possible. Or, I have to do manually one by one?
Any idea?
