access append query disabled mode

  • Thread starter Thread starter S Lee
  • Start date Start date
S

S Lee

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