VBA7 Database connections

[Anonymous]

I have just installed Inventor 2014 and I am working through some vba issues. Can anyone tell me how to work with database connections? "DBEngine.Workspaces(0).OpenDatabase" seems to throw an error now. Not quite sure how to work it out. Any suggestions?

[adam.nagy]

Hi,

Are you working on a 64 bit machine?
In that case the following article should be of help, since using Microsoft DB component from AutoCAD's 64 bit VBA environment (or any other 64 bit process for that matter) has the same issues: http://forums.autodesk.com/t5/NET/32bit-AND-64bit-environment-database-connectivity/td-p/2925668

Cheers,

[Anonymous]

Thanks Adam for pointing me in the right direction.

[Anonymous]

My work around looks to be to use excel. From within Inventor I open and start excel and populate the job number. Then using 3.6 DAO Object Library in Excel I can search the Access data base and populate the excel sheet and then automatically populate back to the vba in Inventor. A little akward, but better than nothing.

[ekinsb]

Try installing the 64-bit version of this component.  This should allow you to connect to an Access database.  One word of warning though is that if you have any 32-bit applications you're using that also need to use Access, they will be broken.  Microsoft doesn't support both the 32 and 64-bit versions of the component to be installed at the same time.

http://www.microsoft.com/en-us/download/details.aspx?id=13255