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

 

I'm getting an error when I try to use data macros in local tables to update data in linked tables. Why?

 

When you design data macros in Access 2010, you can only insert, update, or delete data in local tables, or Access Services web tables inside a web database. If you attempt to insert, update, or delete data in a linked table with a data macro attached to a local table, you'll probably receive this type of data macro execution error in the USysApplicationLog table:

 

"Queries that contain linked tables, action queries, and database references are not allowed in data macros."

 

This also applies even if you link to published Access Services lists from a client database. You can't insert, update, or delete data in the linked Access Services lists by using data macros attached to the local client tables. If you need to update the data in those linked tables, you'll need to use action queries or Visual Basic code.

 

 

See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out

 

 

Back to FAQ main page