Database Maintenance
How does
the table create an Auto number and distinguish it from a text
field? What makes a Query run? Microsoft Access uses the Access
Jet Database Engine. This engine is installed when you load the
Microsoft Access software. The Jet Database Engine reads and saves
the data. The engine also allows users to import and export
information into other programs, such as Microsoft Excel.
All databases need routine maintenance. When you add and
delete objects in a database, the files may become fragmented. This
can happen when you add or delete records in a table. It also occurs
when you add and delete Form Fields, Combo Boxes, or Labels.
In Microsoft Access, the command is called: Compact and Repair.
When you compact an Access database, this utility will copy your
file and arrange the database bits more efficiently on your hard
drive. Compacting makes the database run faster.
Why does a database need to be repaired? Databases can become
corrupted if they are shut down unexpectedly: e.g. the power goes
out when you are editing a record. Network problems can also trash a
database. Sometimes, switching back and forth from Design to Form
View can make a database act goofy.
