I have created two OLAP cubes using the pivot table wizard in excel 2003.
Both cubes pull data from the same MS Access database. The first cube
updates without any problems when I click the refresh button. However the I
get the following error when I try to update the second cube

Client Safety Settings do not allow for pass through queries to the data
source

Microsoft suggests changing one of the registry entries to eliminate this
error but if this was an issue with one of my registry entries would I not
get the error when I update both cubes?

Is there a work around for this error or a way to create a cube so that you
do get this error when you update it?