munkeyroot
Registered User.
- Local time
- Today, 10:57
- Joined
- Jan 13, 2011
- Messages
- 76
Hi Everyone
hope you are all well
i'm not new to access but new to macros, just wondered if is was possible to edit a relationship through a macro?
Background:
Everyday i have to import a new table from a third party DB.
rename the old one ....old ... ..and rename the new.
at this point the "main" table relationship still points to the old table and i have to manually tell the main table to look at the new table, then i can delete the old.
hope this makes sence
Cheers Munk:banghead:
hope you are all well
i'm not new to access but new to macros, just wondered if is was possible to edit a relationship through a macro?
Background:
Everyday i have to import a new table from a third party DB.
rename the old one ....old ... ..and rename the new.
at this point the "main" table relationship still points to the old table and i have to manually tell the main table to look at the new table, then i can delete the old.
hope this makes sence
Cheers Munk:banghead: