We have a VBA program that takes attributes from Autocad to an Access program. In Acad 2013 it works fine but now in 2014 it doesn't.
Both versions of Autocad are on the same environment of
Windows 7 64bit
With the 64bit versions of BOTH software - Autocad and the VBA expansion.
The program doesn't work in 2014 and since 2014 was installed it won't work in 2013 either. So now we have unloaded the VBA expansion pack for BOTH 2014 and 2013 and then reloaded the 2013 back on and it seems the 2013 version is running again. Error code is: Run-time error 429 Activex component can't create object.
The Access Database may now be a sequel database with an Access front end but the case is 2013 works and 2014 doesn't?
Any ideas? I don't think it would be a 32 vs 64 bit because the 2013 version works?
Thanks in advance
Solved! Go to Solution.
In AutoCAD verisons 2013 and older VBA is a 32bit application, that is why AutoCAD VBA runs slow on 64bit AutoCAD. In AutoCAD version 2014 (64bit), VBA is now a new version of 64bit VBA.
So when you say you
"So now we have unloaded the VBA expansion pack for BOTH 2014 and 2013 and then reloaded the 2013 back on and it seems the 2013 version is running again." I'm not sure what you mean.
To try and clarify
1) AutoCAD 2014 (64bit) uses 64bit VBA.
2) AutoCAD 2014 (32bit) uses 32bit VBA.
3) AutoCAD 2013 (64bit) uses 32bit VBA
4) AutoCAD 2013 (32bit) uses 32bit VBA
I would not try and run 32VBA and 64bit VBA on the same computer.
The new 64bit VBA should run much faster than the older 32bit VBA, but there will be compatibilty issues with other 32bit applications.
VBA 64Bit is only available for AutoCAD 2014 and NOT for earlier version of AutoCAD.
Once again AutoCAD 2013 uses 32bit VBA.
1) 2013 AutoCAD 32bit - uses VBA 32 bit.
2) 2013 AutoCAD 64bit - uses VBA 32 bit.
3) 2014 AutoCAD 32bit - uses VBA 32 bit
4) 2014 AutoCAD 64 bit - uses VBA 64 bit.
The download page you show is a bit (very) confusing, because the description would lead you to belive the 64 bit and 32 bit refer to VBA. But 32 bit and 64 bit actually refer to the AutoCAD 32bit or AutoCAD 64 bit versions.
No where in link below does it clarify the Version of VBA that is being downloaded.
That is why I provided the link below
You will notice there is a difference in the Visual Basic editor for 32bit and 64Bit VBA. If you go the the Help/About pull-down menu, VBA 64 Bit is version 7.1.
So is there an actual solution to this other than re-writing everything in .NET? I have already started the rewrite process, but have 10 years of VBA code to rewrite in .NET and just need a crutch until I can get it all finished.
We only have a handfull of machines (4-5) that run Win7 64bit. The rest are all XP machines. If there is no easy solution, then I guess we will continue to run AutoCAD 2012 until I can get all of the important code re-written in .NET (at least another year).
It looks like our biggest issue is the 32bit OLE DB providers and MS Access. Another reason I have started converting everything over to .NET and SQL!
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register