Add-On DBUS doesn't return memory

[Barney]

I'm using Visio 2003 and I have a macro that loops through every page
in my document and runs the add-on "DBUS" to update linked database
records based on the shape properties (=RUNADDON("DBUS") ). I have
noticed that every time it runs, it takes memory (from the PageFile in
my case) and does not return it when it has completed execution.
After executing on about 10 pages in my document, Visio crashes with
an "Out Of Memory" error.

Does anyone have a solution to this? I am thinking that it could be
leaving the ODBC database connection open, rather than closing it.
Can anyone suggest a way of opening a database, updating records (or
shapes based on the records' contents for a two-way connection), and
closing the database in VBA without using the DBUS add-on?

Thanks.

 

[David Parker]

I think it does keep the link open.
You can write your own code to read the User cells to get the link
information, then do the refresh yourself.
When I did a similar thing back in '98 using an earlier version of the DB
Wizard, it reduced update times by 60 fold!

 

[Barney]

I guessed this may be the problem, but I am not sure how to do it
myself with VBA code.
Could you give me a bit of example code to do this?

Thanks.