Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NickAtWork

    Frontend and Backend .MDE question.

    There is a Microsoft Knowledgebase article that says if you have problems, make the "assocoated databases" into mde's.
  2. NickAtWork

    Frontend and Backend .MDE question.

    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...
  3. NickAtWork

    Frontend and Backend .MDE question.

    I wonder if this is some kind of security patch gone wrong!
  4. NickAtWork

    Frontend and Backend .MDE question.

    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...
  5. NickAtWork

    When NOT to Enforce Referential Integrity

    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...
  6. NickAtWork

    When NOT to Enforce Referential Integrity

    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...
  7. NickAtWork

    When NOT to Enforce Referential Integrity

    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...

Part and Inventory Search

Back
Top