access append query disabled mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S Lee - 14 Feb 2008 05:11 GMT

I created an Access 2007 append query. I try to run it but it tells me
disable mode won't allow the query to run. What the heck is disabled mode? I
searched office online help and could not find a reference or topic on it.

Reply to this Message

Allen Browne - 14 Feb 2008 05:13 GMT

Have you told you Access 2007 that you trust the folder where the database
resides? Some things are disabled if you have not done that.

You can set this through:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

More info about adapting to the new version:
http://allenbrowne.com/Access2007.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I created an Access 2007 append query. I try to run it but it tells me
> disable mode won't allow the query to run. What the heck is disabled
> mode? I
> searched office online help and could not find a reference or topic on it.

Reply to this Message