Skip to main content

Access Junkie - MVP Alumnus

Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
MSDN Articles
Contact Us
About Us
Member Login
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