Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Wed May 26 00:48:51 CDT 2004
I don't know why but I once had a problem with relationships to. Relationsships are saved in a hidden read only table. That is, read only only when you access by view. You can write some code to read, change and add relationship to that table. So if you have a lot of relations that needs to be moved from the FE to the BE you could consider wrting sme code for it.... Erwin -----Oorspronkelijk bericht----- Van: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Namens Arthur Fuller Verzonden: dinsdag 25 mei 2004 21:33 Aan: 'Access Developers discussion and problem solving' Onderwerp: [AccessD] Ooops! Ok, we all know I'm prone to idiocy, but that aside.... I have been hopping between FE and BE and I declared relationships in the FE thinking that I was in the BE. The declarations now conflict. (I finally realized that something was wrong because the "Enforce RI" checkboxes were unavailable.) So... The question is, how to fix it. The relationships are all correct in the BE and a few are wrong in the FE. If I delete all the relationships in the FE, will that fix it? If I do nothing, leaving conflicting definitions, what will happen? What I wish is that within the FE, I will simply "see" the relationships declared in the BE. (What I also wish, but that is another story, is that this would work as it does in ADP files, where you can have multiple diagrams, each devoted to a subset of the data.) Recommendations? Should I just kill all the relationships and the whole diagram in the FE? TIA, Arthur -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com