ODBC linked data stores (e.g. Oracle tables) are not updatable unless they contain a primary key. Scriptoria will automatically add a primary key field to Access tables that do not contain a primary or unique index. The added field specifies the Auto Number data type. A unique number is assigned to each existing row of the Access table satisfying the ODBC updatable requirement.
The first time Scriptoria is loaded for a given database or when one or more new tables added, Scriptoria checks to ensure a primary or unique index exists. If one is not found, the following form is displayed:
Pressing “Yes” adds a primary key to the displayed table. If any other new tables are found not to contain a primary key, this form is re-displayed. To add primary keys to all tables that require one, press the “Yes To All” button. “No” and “No To All” exhibit identical but opposite functionality as “Yes” and “Yes To All”.
This form may also be displayed using the Tools | Add Primary Key menu item.