HiTechCoach | Access Tutirials, TIPs, Examples
You are here:
Access Tables- Tips and Tricks
Access Tables- Tips and Tricks
Autonumbers - what they Are and Are Not...
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.
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.
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:
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.
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.
The Evils of Lookup Fields in Tables
Why you need to avold this table property
ACC2000: How to Build a Visual Basic Module to Print a Report in Landscape Mode on Legal-Size Paper
Office Template Store
What happens to those free Windows 10 upgrades after July 29, 2016?
Preview a Report and move to last page
Deploying Application (Front End) Updates
Microsoft Most Valued Professional MVP - Access Expert
Trust Center in Access 2007, 2010, 2013, and 2016
Why are there not many articles or examples for Access 2007, 2010, and 2013?
Splitting your Access database into application and data
What is the Access Runtime Version?