Figuring out vba code for "Link to Database"

[Mikhail]

Hi,

I have a visio drawing that's linked to a database using the database
wizard, but every time I open the document I have to re-link to the database
(find it, point to the location, etc). I'm trying to write a vba macro to do
this automatically, but the macro recorder doesn't seem to record the link to
database code.

Do you guys know how I might do this?

Thanks.

 

[David Parker [Visio MVP]]

Are you using a saved DSN or just the MS Excel or MS Access temporary ones?
You need to create named DSNs for your purposes.

 

[Mikhail]

I was using the temporary ones, but I just created a permanent one and still
can't figure out how to get it to work...

Please advise. Thanks a lot.