Access 2010 FAQ
How can I publish web forms and reports based on the USysApplicationLog to the server?
Unfortunately, you cannot have database objects - queries, forms, and reports - bound to the USysApplicationLog table before you publish your web database to the server, because the Web Compatibility Checker prevents you from publishing if you have objects bound to this table. The good news, however, is that you can bind database objects to the USysApplicationLog linked table after you publish.
For my web applications, I created a web form and web report against the USysApplicationLog table in a web database. I then imported those two objects into a separate web database and removed these objects from my database before publishing. I can now import these two objects from my master copy into any published web application and then use them in both Access client and the browser to easily view any data recorded in the USysApplicationLog table.
See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out
Back to FAQ main page