Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
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