Connecting to a MS Access DB

General Questions/Discussions
1

Hi,

How can I can connect to a MS Access database in order to reverse engineer it?

Thanks

2

Hi Yeti,

Thanks for your post. We are sorry that we do not support MS Access database.

Best regards,
Lilian Wong

3

There’s no way to use a custom jdbc connection?

4

Hi Yeti,

Thanks for replying. Please try the Instant Reverse for JDBC instead of Object-Relational Mapping (ORM) feature. More details about Instant Reverse for JDBC can be found from:
http://www.visual-paradigm.com/support/documents/vpumluserguide.jsp?pt=9&ch=1&sec=8

Hope this helps. Please let me know if there is any further question.

Best regards,
Lilian Wong

5

Thanks,

In order to connect to my access db, I’m using an ODBC bridge, but Vp keeps saying it doens’t find the driver class.
I didn’t provide any jar driver for I’m using ODBC…

6

Hi Yeti,

Thanks for replying. Our engineers tested that leaving JDBC Driver blank can reverse the JDBC ODBC (you can refer to attached image). Could you please capture a screenshot of your configuration and send me the vp.log file (Inside VPSuite/bin folder) to take a look? Thanks in advance!

Best regards,
Lilian Wong

reverse_jdbc.png

7

Hi,

That’s ok.

I found a jdbc driver for access and set it up;)

8

Hi Yeti,

That’s good. Please feel free to ask if there is anything I can help.

Best regards,
Lilian Wong