Can Attributes Of Tables/Relationships, Etc. Be Changed Programatically?
Hi All, Development stage of setting up a new solution here. I CONSTANTLY have to unhook the relationships I’ve built via the Relationships tab on Tools, then change the Required element of a few controls on a table from yes to no, make some other adjustments to the attributes of various controls, then copy just the structure (so that the primary key resets to 1) to another name, delete the first table, rename the new table to what it should be, import some data (from another system I’m converting from), run some queries that find duplicates, missing data, deletes some garbage, etc. I then have to redo the Required elements I need, rehook the relationships and all the other stuff I had to cancel just to get the data over. Now, don’t get me wrong…I’m amazed I can even DO all of this without coding anything. But… The terrible part is, my boss is going to eventually want to take this existing mdb and make one identical too it but with only certain of the tables populated with some dat
