Update Database Connection

[MAN]

Ive created a load of boxed and linked a database table to each of th
boxes, is there any way to update all of the boxes at once instead o
rightclicking on all of them individually and clicking them to update

 

[David Parker]

If you are using the Database Wizard, then there is an option to add mouse
actions to the page - this includes Updating all linked shapes on the page.

 

[MAN]

Ok Im runnign a danish version so im gonna try to translate it as goo
as i can -

When i use the database wizard to add the mouse action you talk about
have 2 choices,
either updating all linked shapes as you wrote
or
update the database with the data from the shapes.

now my new problem is i can do what you adviced me to do, and clic
updating all linked shapes on the page, and when i click it on th
page,
i get the error message - the table XXXX, which your shape refers to
does not exist in the ODBC-datasource
even tho i have already created an ODBC
i can update them individually but not linked.

i have no problem updating the database with the linked shapes dat
tho.. its wierd

 

[David Parker]

What type of "database" is it?
What version of Visio?

 

[MAN]

it is Visio 2003 (11.3216.5606)
its a Access Database also 200

 

[David Parker]

I have had some problems with FIle DSNs for Access, but no trouble with
System or User ones. Also, I assume that you creating a named DSN, not just
the temporary one with the Access Driver?