Update Query for new records not working 2007

[Mmattson]

I am using an update query comparing 2 tables to add new records from table 2 to table 1. This worked fine until we upgraded to Office 2007. Is this a function of 2007?

I am not getting any prompts to OK, "You are about to update 1500 records"

Thanks for any help.

-Marcus

 

[Mmattson]

Sorry. I found my solution. Access 2007 has a message bar that seems to be off by default. This replaces the "trusted" settings from previous versions.

Cheers!