Database auditing needs to be planned before you upsize your database.
You can either add simple fields which record who created or updated data, and when this occurred,
or choose to use the full database auditing feature to record all changes to data in particular tables
(this also requires the simple fields to be present).
Auditing needs to be specified BEFORE you start analysing the Access databases.
Ensure that you have been through a dummy run creating a database without auditing before
attempting to create a database with auditing, otherwise you are likely to get confused.
| auditing options |
Thist form has two check boxes which allow you to switch on the auditing,
the following steps only apply when using full database auditing |
| create audit database |
Before upsizing the main database, you must have a name defined for the auditing database,
this screen allows the auditing database to be named and created. |
| Now Analyse the Access databases, this will also create auditing fields |
| select tables |
With the databases analysed, this screen allows tables to be selected for full database
auditing. |
| Now migrate the data and complete upsizing the Access databases.
Note that data can not be safely editing until the auditing tables have been created
otherwise failures in the auditing triggers will be encountered because the
tables do not exist. |
| create auditing tables |
This final step creates the physical auditing tables. |
You will need to ensure that users have INSERT permissions on the auditing tables
in the auditing database, this is most simply accomplished by creating an Audit database role
in the auditing database which is granted INSERT permissions on the tables, and then adding
all users into the auditing database with the Audit database role.