HostWeb Forums » Microsoft Databases » microsoft.public.access.queries » Re: Query Access 2007 "Disbled Mode"

Topic: Query Access 2007 "Disbled Mode"

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 8/22/2006 3:09:02 PM

By: Anonymous

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

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 8/22/2006 4:58:31 PM

By: flea

Re: Query Access 2007 "Disbled Mode"

If this helps... How to check if your solution is in Disabled mode

http://blogs.msdn.com/thirdoffive/archive/2006/08/16/700615.aspx

Salim Nice wrote:
> 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

Page 1 of 1 Pages