ODBC data source Table error

[rhatcher]

Sorry for the duplicate post but I am desperate and am trying a more
active forum.

Original post:

I have a Visio drawing with one shape that is linked to an Excel
spreadsheet. If I right click and select "Refresh Shape Properties"
it will refresh correctly. However, if I deselect the shape and right
click on the drawing and select "Refresh Linked Shapes" I get an
error response "the table "VisioTransfer" specified in the
selected shape does not exist in the ODBC data source.


The only data source file assigned does have the table
"VisioTransfer" in it, otherwise "Refresh Shape Properties"
wouldn't work either.


And suggestions how to deal with this?


I plan to add many duplicates of the shape to the drawing and would
like to be able to use the function "Refresh Linked Shapes".



Update:
Since then I have tried several ways to evaluate the problem, to no
avail, yet. I tried to duplicate the problem by creating a simple
duplicate scenario file. However the dup file works fine and so far I
have only been able to eliminate some things.

I tried running the event recorder to record the events at the time of
the failure and came up with the following results.


The following is three examples of what happens after I right click on
the Visio page and select "Refresh Shapes" In the WORKING file:

RGB1.VSD
3679 >EnterScope 1460 [6251;0;1460]
3680 <ExitScope 1460 [6251;0;1460]
3681 >EnterScope Refresh Shapes [66781;0;Refresh Shapes]
3683 <ExitScope 1245 [66781;0;1245]

10087 >EnterScope 1460 [6251;0;1460]
10088 <ExitScope 1460 [6251;0;1460]
10089 >EnterScope Refresh Shapes [67716;0;Refresh Shapes]
10091 <ExitScope 2180 [67716;0;2180]

12467 >EnterScope 1460 [6251;0;1460]
12468 <ExitScope 1460 [6251;0;1460]
12469 >EnterScope Refresh Shapes [68192;0;Refresh Shapes]
12471 <ExitScope 2656 [68192;0;2656]

I beg forgiveness for being completely ignorant of what is going on
here but my observation is that the Enterscope # and Exitscope #
numbers are the same for the first events and "EnterScope Refresh
Shapes" is always the third event. The final Exitscope is always a
different number.

The following is three examples of what happens after I right click on
the Visio page and select "Refresh Shapes" In the FAILED file:

1572 >EnterScope 1460 [6250;0;1460]
1573 <ExitScope 1460 [6250;0;1460]
1574 >EnterScope Refresh Shapes [66226;0;Refresh Shapes]
1576 <ExitScope 690 [66226;0;690]

17055 >EnterScope 1460 [6250;0;1460]
17056 <ExitScope 1460 [6250;0;1460]
17057 >EnterScope Refresh Shapes [68717;0;Refresh Shapes]
17059 <ExitScope 3181 [68717;0;3181]

18103 >EnterScope 1460 [6250;0;1460]
18104 <ExitScope 1460 [6250;0;1460]
18105 >EnterScope Refresh Shapes [68924;0;Refresh Shapes]
18107 <ExitScope 3388 [68924;0;3388]

Essentially I get the same results. I find it interesting that the
error report that I get is not related to anything in the event log.
Does this tell me that the error is coming from outside Visio? Or?

The saga continues...

 

[rhatcher]

After many long hours of troubleshooting, I found the problem, it seems
to be a bug, but I really don't know. The drawing contained six
layers only one of which contained the shapes that were dropped from
the stencil. As a last ditch effort I backed up the file and deleted
all layers except the working layer and the problem vanished. The only
things on the deleted layers were imported CAD images; in fact, most of
the layers were imported from CAD. I opened a copy of the backup file
and tried deleting the layers one at a time to identify the offending
layer but all additional layers had to be deleted to clear the problem.
I repeated this test changing the order of deletion as well. Heres the
kicker, I deleted all the additional layers from a copy of the file
made sure "Refresh Linked Shapes" worked, next, I copied all the layers
into the new file from another copy and it works!!!!!!! Just the act
of removing the layers and replacing them with identical layers from a
copy of the file cleared what ever the problem was.