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

B

BongoBill

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?
 
T

tina

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

hth
 
B

BongoBill

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.
 
T

tina

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.
 
P

Pete D.

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.
 
Top