Remove database (Access) Link

[Blackend]

I have made a drawing wich have some shapes linked to a database (Access).
Now a customer would like to have copy's of my drawing.
My customer dosen't have the database, but i still whan't him to be able to
use the "smart" symbols on the drawing.

I have tryed to manualy delte the User.ODBCConnection on the shapesheet, and
then everything works fine - the DB link is gone.

Now all i whant to do (To help my colleagues, so they don't need to open the
ShapeSheet (They are not programmers)) is to make a menu (Right click on the
shape/page) and then with a macro or something else, remove the database
connection (maby by removing the User.ODBCConnection line).
Only thing is - i don't know how to do this.
Maby there is a much better way of doing this?

Anyone?

Thanks in advance
Ulrik

 

[Chris Roth [ Visio MVP ]]

The DB Wiz allows you to remove links on the selected shapes. You just have
to get through the first few screens. Might be easier to teach the people
how to use the wizard to get rid of the stuff.

- Select the shapes to clean
- Click the DB Wizard "Next" button until the fourth screen
- Click "Remove links" and you're done!

--

Hope this helps,

Chris Roth
Visio MVP