edit shape links to database

[Willson]

I have outdated shapes in Visio that are looking for fields that are no
longer in our database.

For example:

A shape will look for the 'process id' field in the 'process' table but we
have moved that field to another table since we created the shapes. (we
changed the structure of the database since we last made these shapes)

The information in the shapes right now is correct, but when we try to
update or refresh the shapes, Visio cannot handle it.

I was wondering if there was a way to re-establish a link to the shape
properties.
If that doesn't make any sense, let me know and I will re-word it.


Thanks,
Willson

 

[wr]

Hi Wilson,

Rerun the database wizard I should say.

first remove the database connection information in the shapesheet of those
shapes
like user.odbcconnection and odbcchecksum and action rows pointing to
runaddons
(if present afcourse)
then rerun the database wizard (tools/addons/visio extras/database wizard)
for the shapes that you want to refresh

Rene

 

[Willson]

wr,

Thank you for your reply.

I however am looking for a more automated approach if there is one. We have
well over 1000 shapes to deal with here. (and each shape has 2 shapes inside
of it)

When i re-link the database, and try to 'select record' by right clicking on
a shape, i get an error saying Visio cannot connect to the DB.

 

[wr]

Hi Wilson,

If you alter the table in the User.ODBCconnection cell then you are settled
after that
Because if only another table is the problem you can change that there
If you automate that you need to loop through strings in this user
connection cell check for
something like "ODBCtable=OldTable" and change OldTable to NewTable

René

 

[wr]

Hi Wilson,

If you alter the table in the User.ODBCconnection cell then you are settled
after that
Because if only another table is the problem you can change that there
If you automate that you need to loop through strings in this user
connection cell and check for
something like "ODBCtable=OldTable" and change OldTable to NewTable

René

 

[LostBrain]

Have you tried to just select all shapes and then run the Database Link
Wizard? That should reset the DB connection for all shapes.