Microsoft announced on Monday that it will be bringing a new default for Windows Office users that is said to "block Internet macros by default." Microsoft's new Internet macro blocking scheme will be ...

5 seconds in google tells me that you can call Access with the "/compact" command line switch. Also, there's a KB article at support.microsoft.com that give further details.

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

After rolling back restrictions on internet macros in Office, Microsoft now says it is was a temporary change and that it will be bring back the ban on macros as the default for all users in future.