Query Access 2007 "Disbled Mode"

G

Guest

I setup a new Access Database in 2007 but saved it as 2003. I linked ODBC
three tables to a SQL Server. I then wrote a Make Table Query that had a
criteria for a certain type of record. When I run the Make Table Query it
says in the lower left corner the following error:

"The action or event has been blocked by Disabled Mode."

I have searched for settings related to this and I can't find any. Can
anyone advise me what I need to do to get the query to execute. I have Admin
rights on both the local machine and SQL. If I change it to a Select Query
it will run fine.

Many thanks for any help.

Salim Nice
 

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 query ODBC--call failed 3
Access 2010 append query to SQL is very slow 0
Probable Access 2007 SP2 Error: Query too Complex 0
query links to SQL server and mdb table 1
access append query disabled mode 1
Query is too complex after install Access 2007 SP 2 !? 25
Combine Duplicates in Query 0
Make table query won't run but Select will 3

Top