I have verified my VBA code is compiled and without errors. The problem appears to be that the back-end is not an mde, and I cannot make it so, because it is part of a proprietary database program. This didn't used to be a be a problem with 97 and early 2000. Is this the result of a security...
I am having trouble creating an MDE. I get the error "Access was unable to create an MDE database". Accoding to the Microsoft Knowledgebase, this is an expected outcome if there is erroneous VBA code (which I do not have) or if the mdb you are trying to convert "refers" to...
Thanks for your responses.
I always use level 2 as a baseline when I am in control. I don't need orphan records any more than my users do!
I spoke to the creator of the database I inherited. He said he used the non-enforced relationships so that history would be maintained in the main table...
Thanks Jerry.
We're in agreement as far as you go. I guess another way to phrase my question is: "What is the difference between a relationship that does not enforce referential integrity and no relationship at all?" Or "What is the purpose of making a relationship if you are...
I have inherited a help desk database where some relationships enforce referential integrity, and some do not. One relationship is "Indeterminate" meaning that at neither end is there a primary key.
I see that in Access 97's Database Wizard creation "Asset Tracking.MDB" it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.