Access Links

Access Links

Access Tables- Tips and Tricks

  • Hits: 1497
    Autonumbers - what they Are and Are Not...
  • Hits: 1736
    AutoNumber field is not reset after you compact an Access database
    This article applies to a Microsoft Access database (.mdb or .accdb) and to a Microsoft Access project (.adp). When you delete the last record or records in a table or in a form that has an AutoNumber field, and then you compact the database, the AutoNumber field does not start at the next higher number when you add new records.
  • Hits: 2029
    Fixing AutoNumbers when Access assigns negatives or duplicates
    In Access 2000 and later, an AutoNumber field may begin assigning extreme values, negatives, and even duplicates. The attempt to assign a duplicate fails if the field is primary key, so it may not be possible to save new records in an affected table.
  • Hits: 1686
    Use Autonumbers properly
    In a table I'm using an Autonumber Field as the primary ID. But if the user creates a new record and closes the form without saving it, the Autonumber field still increases by one. This creates gaps in the continuity of the primary key field. How can I:
  • Hits: 1914
    Fundamentals of Relational Database Design
    Overview Database design theory is a topic that many people avoid learning for lack of time. Many others attempt to learn it, but give up because of the dry, academic treatment it is usually given by most authors and teachers. But if creating databases is part of your job, then you're treading on thin ice if you don't have a good solid understanding of relational database design theory. This article begins with an introduction to relational database design theory, including a discussion of keys, relationships, integrity rules, and the often-dreaded "Normal Forms." Following the theory, I present a practical step-by-step approach to good database design.
  • Hits: 1815
    Access Database Corruption Repair Guide
    Database Corruption is when an error occurs in the binary file format of a particular database. The result can be an unusable database or one where inconsistent behaviour occurs (such as random errors). Access MDB Database corruption is actually very common, however Access (and the Jet Database Engine) will fix minor corruption issues in databases during the normal use of reading/writing table data. Therefore in many cases your database will become corrupt but you will never know anything about it! This can be very risky because corruption often spreads and gets worse over time if not fixed.
  • Hits: 486
    The Evils of Lookup Fields in Tables

    Why you need to avold this table property

Latest News