VBA to truncate or delete Access database tables
Access SQL does not have anything like TRUNCATE table. There is also no way to run a DROP table query.…
TRUNCATE and Access
There is no TRUNCATE in Access. This post explains how to achieve equivalent results in Microsoft Access.
Modifying Access Form Controls
Modifying controls on forms is as simple as opening the form in Design View, selecting the control and opening the…
Access database tables
Tables are used to store data. They are similar to worksheets in that they store data arranged in tabulated form,…
The Primary Key in a database table
Understanding the Primary Key (“PK”) concept is critical to learning about Relational Databases. A table can exist without a PK,…
A DELETE query in Microsoft Access
OK so now you must tread lightly! DELETE queries are destructive — there is no “undo”! The Golden Rule is:…