Visio and Unrecognized Database format

[Maredith]

We have an MS Access application and MS Access back-end database that stores
employee information. We call Visio 2003 to generate an org chart but the
data is managed in the front-end. Recently, new users are having a problem
with Visio. I don't have the full test of the error message but it includes
"Unrecognized database format" and accde. Their machines were recently
configured or reconfigured but we are 'supposed' to have standard
configurations. I don't have access to their desktops but I suspect the Visio
SP3 has not been installed.

Before I request someone go in circles - has anyone experienced this
problem? Does it sound reasonable to start going one-by-one and seeing if
installing SP3 helps? Does anyone have a better suggestion?

 

[Chris Roth [Visio MVP]]

Hi Maredith,

No clear idea, but I'll take a guess or two that might trigger an "aha!"

Have you upgraded Access in the meantime? Was the solution written for
an older version of Access?

Does your solution drive Visio wholly from Access, or do you call into
VBA within a Visio file?

Or are you using the command-line parameters to activate the Org-chart?

--
Hope this helps,

Chris Roth
Visio MVP


Visio Guy: Smart Graphics for Visual People

Articles: http://www.visguy.com
Shapes: http://www.visguy.com/shapes
Dev: http://www.visguy.com/category/development/
Forum: http://www.viguy.com/vgforum

 

[Maredith]

Hi Chris,

Thanks for tackling this - I'll try to answer your questions appropriately.

The application was first built using Access 2003 but I upgraded it almost a
year ago and it has been working with Access 2007 and Visio 2003 fine since
then. It still works on my laptop that has Access 2007 and Visio 2003 and on
desktops of users who have been users for a while. The application does NOT
work now on my desktop that was reconfigured, (e.g. Vista installed, Office
2007 reinstalled, Visio 2003 reinstalled) or on a new user's desktop who's
desktop was configured with XP a couple months ago.

All the code is in Access. The source data for the Organizational Chart
people is first filtered and copied into a local table in the same front-end
database that has the code.

A single subroutine in an Access module declares various Visio objects and
calls Visio with
Set objVisio = CreateObject("Visio.Application") and
Set objAddOn = objVisio.Addons.ItemU("OrgCWiz")
then most of the 'work' is done either with methods to the visio objects or
building a command string and using
objAddOn.Run strCommand

I don't remember just when we got Visio 2003 SP3 but I'm suspicious the
problem may be because the two recently configured that I can "get to" do not
have SP3. However, getting any changes in a desktop's configuration requires
a lengthy request/approval process so I was trying to make a smart request -
not just grasp at straws.

Thanks,
Maredith

 

[Barb Way]

Visio 2003 was released before the Access 2007 ACCDB format came out. Do
you have Access 2007 installed on the same computer as the Visio 2003
system? Check in the ODBC Data Source to see if the driver that you are
using to connect to the Access database is able to support ACCDB. On my
Access 2007 system, I see two driver types listed:

"Microsoft Access Driver (*.mdb)"
"Microsoft Access Driver (*.mdb, *.accdb)"

It's possible that you will be able to install Access 2007 to obtain the
second type, and use it to create your ODBC connection. I have not tested
that combination myself, however. I tend to match Office and Visio
versions, so I have Visio 2007 and Office 2007 together.


Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

Hi Chris,

Thanks for tackling this - I'll try to answer your questions appropriately.

The application was first built using Access 2003 but I upgraded it almost
a
year ago and it has been working with Access 2007 and Visio 2003 fine since
then. It still works on my laptop that has Access 2007 and Visio 2003 and
on
desktops of users who have been users for a while. The application does NOT
work now on my desktop that was reconfigured, (e.g. Vista installed, Office
2007 reinstalled, Visio 2003 reinstalled) or on a new user's desktop who's
desktop was configured with XP a couple months ago.

All the code is in Access. The source data for the Organizational Chart
people is first filtered and copied into a local table in the same
front-end
database that has the code.

A single subroutine in an Access module declares various Visio objects and
calls Visio with
Set objVisio = CreateObject("Visio.Application") and
Set objAddOn = objVisio.Addons.ItemU("OrgCWiz")
then most of the 'work' is done either with methods to the visio objects or
building a command string and using
objAddOn.Run strCommand

I don't remember just when we got Visio 2003 SP3 but I'm suspicious the
problem may be because the two recently configured that I can "get to" do
not
have SP3. However, getting any changes in a desktop's configuration
requires
a lengthy request/approval process so I was trying to make a smart request
-
not just grasp at straws.

Thanks,
Maredith