the action or event has been blocked by Disabled Mode!

[thomasgist]

When trying to append to a table, I get, "the action or event has been blocked by Disabled Mode!"

Any solutions will be greatly appreciated.

 

[boblarson]

Which version of Access on which version of Windows?

 

[thomasgist]

I am using Access 2007 on xp

 

[boblarson]

Have you done this yet:

http://www.btabdevelopment.com/ts/default.aspx?PageId=13

 

[thomasgist]

Yes, I have.
I am still getting the same message.

 

[boblarson]

What action are you trying to do?

 

[thomasgist]

i am attempting to create a new table using data from another (normalization)

 

[boblarson]

i am attempting to create a new table using data from another (normalization)

No, specifically, are you using a macro/VBA to do so? If so, what is the exact macro actions or specific VBA you are using?

If not using either of those, then please explain - exactly - what steps you are doing (remember, I can't see anything of what you have so I am at your mercy of explaining what you are doing so I can figure out what you may not be doing correctly or if there is another problem).

 

[thomasgist]

I am using an append query.
I created a select query
On the design tab I clicked append
Run

------ the action or event has been blocked by Disabled Mode!

 

[boblarson]

Can you go into that query into design view and then on the VIEW tab, select SQL VIEW and you should see the SQL Statement. Then copy and paste that here.

 

[thomasgist]

INSERT INTO VehicleService ( [License Plate Number], [Service Date], [Service Cost], [Service Description], [Service & Gas Receipts] )
SELECT Vehicles.[License Plate Number], Vehicles.[Service Date], Vehicles.[Service Cost], Vehicles.[Service Description], Vehicles.[Service & Gas Receipts]
FROM Vehicles;

 

[boblarson]

INSERT INTO VehicleService ( [License Plate Number], [Service Date], [Service Cost], [Service Description], [Service & Gas Receipts] )
SELECT Vehicles.[License Plate Number], Vehicles.[Service Date], Vehicles.[Service Cost], Vehicles.[Service Description], Vehicles.[Service & Gas Receipts]
FROM Vehicles;

Well, I don't see anything wrong with that. And I found this:
http://office.microsoft.com/en-us/a...d-mode-from-blocking-a-query-HA010256403.aspx

Which seems to say that it is a trusted database problem. So, I know you already said you did that already. But where is this database located? Is it on a network share, or is it actually on your machine? What directory is it in and when setting the trusted location did you remember to check the INCLUDE SUBFOLDERS check box if the trusted location you set was not on the specific folder? You can't set the trusted location to be the root drive (C:\ drive for example). Also, I know you are on WinXP so this shouldn't affect you but in Vista and higher you can't place your database in to the C:\Program Files folder (or subfolder).

 

[thomasgist]

INSERT INTO VehicleService ( [License Plate Number], [Service Date], [Service Cost], [Service Description], [Service & Gas Receipts] )
SELECT Vehicles.[License Plate Number], Vehicles.[Service Date], Vehicles.[Service Cost], Vehicles.[Service Description], Vehicles.[Service & Gas Receipts]
FROM Vehicles;

 

[boblarson]

INSERT INTO VehicleService ( [License Plate Number], [Service Date], [Service Cost], [Service Description], [Service & Gas Receipts] )
SELECT Vehicles.[License Plate Number], Vehicles.[Service Date], Vehicles.[Service Cost], Vehicles.[Service Description], Vehicles.[Service & Gas Receipts]
FROM Vehicles;

Well, I don't see anything wrong with that. And I found this:
http://office.microsoft.com/en-us/ac...010256403.aspx

Which seems to say that it is a trusted database problem. So, I know you already said you did that already. But where is this database located? Is it on a network share, or is it actually on your machine? What directory is it in and when setting the trusted location did you remember to check the INCLUDE SUBFOLDERS check box if the trusted location you set was not on the specific folder? You can't set the trusted location to be the root drive (C:\ drive for example). Also, I know you are on WinXP so this shouldn't affect you but in Vista and higher you can't place your database in to the C:\Program Files folder (or subfolder).

 

[thomasgist]

The table was populated when I remove a multi-value column from the query.
Thank you for your help.