The USysApplication (log) table is a new feature of the Microsoft Access 2010 table object collection and is utilised with the new feature also introduced to this version called Access data macros.
There are five event driven macros that is bound to an Access table that can trigger a macro automatically. However, if there is an error, the system populates a record to the USysApplication table which is a system table keeping track of errors that failed to execute properly.
Microsoft Access 2010 Table: USysApplication Log Table New To Microsoft Access
Why we now have this feature for Access 2010 table objects is as follows:
- Microsoft Access uses it to log any (table) data macro failures that it encounters while executing from the table events and any named data macros too.
- You can use this table for debugging purposes to test data macros problems since you cannot step and debug these types of macros.
- This version of Microsoft Access also uses this table to record any errors when publishing or synchronising to the web (via SharePoint server or other Access Services).
There are two places where you can locate and then view this system table as this table generates itself as and when it’s required.
The first place it can be found will be to the status bar (right hand area) where a clickable icon appears. The other place can be found in the ‘back-stage’ File tab section (see above image).
Microsoft Access 2010 table section in the navigation pane will also list the USysApplication table providing you unhide the system table’s options first.
Keep an eye out for my latest eBook release which covers Access 2010 Macros. For the time being, the rest of my eBooks are available to you NOW!
Tags: access 2010 data macros, access 2010 table, access error log table, MS Access, ms access tables, usysapplication log table
To unhide a system table in Microsoft Access, you need to go to Access Options (2007 & 2010) and choose the ‘Current Database’ and click the ‘Navigation Options…’ button.