update and append queries

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I created a few 2007 access queries that would append or update
various tables. This is working fine on one machine, but when I
installed access 2007 on another machine and try to run the exact same
queries, nothing is ever updated/appended. Is there a security setting
i am missing...I can make tables just fine...it's the append/update
that won't work properly
Thanks
 
Hi Brett,
have you set up a trusted location for the database on each computer?
If you need more info on trusted locations, search Access help.
 
Back
Top