CODEWITHSUNDEEP
databasems-accessvisio
AlexT
AlexT

Reputation: 1

Visio reverse engineering MS Access - missing driver

I am trying to use the "reverse engineering" feature of Visio to document an existing MS Access database.

I have done that in the past with decent results but I am having an issue at the moment.

Visio doesn’t propose me the MS Access driver - I only have these

Driver options

(Generic ODBC works but is fairly limited in terms of information retrieved).

I am trying to “install” / activate the Access driver but to no avail.

Install options

What am I doing wrong ?

This is Microsoft® Visio® Plan 2 MSO (Version 2206 Build 16.0.15330.20260) 64-bit

Upvotes: 0

Views: 483

Answers (1)

Albert D. Kallal
Albert D. Kallal

Reputation: 49049

If you running office x64 version, then you need to install Access x64, or at the very least install the x64 bit version of the access data engine.

So, since now most office versions default to x64 bits, then you need a x64 bit driver for Access.

You can download the drivers here - they should work:

Microsoft Access Database Engine 2016 Redistributable https://www.microsoft.com/en-us/download/details.aspx?id=54920

Make sure you choose + install the x64 bit version if you are in fact running office/Visio x64.

Do keep in mind while Visio can pull and diagram the database, the options to create a database or forward engineer a database are long gone and removed from Visio. So changes made to that diagram and the Access schema in that diagram can't be sent back to Access, or any other database.

Upvotes: 2

Related Questions