My update query will not update. How do I trust it?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created an update query in a database that is in a trusted location. When
I veiw the results from design view, it is correct, but when I run the query,
the table is not updated.

How can I make it work?
 
are you getting an error message of any kind when you run the query? if so,
what does it say?

hth
 
No, there is no error message. I am a new user of Acess 2007 (I have used
older versions extensivily). I believe that Access 2007 has security built
in such that it will not allow queries or macros that make changes to data to
run unless you somehow "trust" them. I don't know how to allow it to run.
 
sorry, hon, i can't help you with A2007. perhaps somebody else will jump
into this thread and save the day. good luck with it.
 
First click on the round microsoft button top left access window. Click
options, trusted locations and add your datafile directory location. Now it
will be trusted.
 
Back
Top