update and append queries

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
 
J

Jeanette Cunningham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update and append queries 2
append and update queries to PostgreSQL backend very slow 6
Using Append Queries with Linked Tables 3
Append to two different tables 23
Queries have stopped displaying error messages 1
Append Query question - Is this scenario possible? 1
Slow Append 19
insert, append from form to table 3

Top