ACA_db for AutoCAD Architecture database connectivity
About | Download
| System requirements |
License agreement | Revision History
Make use of AutoCAD Architecture
or AutoCAD MEP more fully in your BIM
process. Property Set values
can automatically be updated
back and forth to one or many
If you make changes to the Extended Data values within a Property Set they can be
synchronized back to the external database. Any Property in a Property Set
Definition can be exported and all editable Properties can be imported.
ACA_db will improve the BIM
process and experience and will
improve quality of your data and
remove redundancy and conflicts
Contact us to get a time
limited license file for free.
ACA_db_2013_4.zip (156KB) only
for 2013, 2014 and 2015. Version 4.0 supporting 32-bit and 64-bit.
ACA_db_2010_4.zip (159KB) only
for 2010, 2011 and 2012. Version 4.0 supporting 32-bit and 64-bit.
ACA_db_2010.zip (236KB) only for
2010, 2011 and 2012. Version 3.0. 32-bit only.
ACA_db_2009.zip (236KB) only for
2009-versions. Version 3.0. 32-bit only.
ACA_db_2008.zip (236KB) only for
2008-versions. Version 3.0. 32-bit only.
ACA_db_samples.zip Access and
SQL Server sample databases.
AutoCAD Architecture 2015 (ACA 2015) or AutoCAD MEP 2015 (AMEP 2015).
AutoCAD Architecture 2014 (ACA 2014) or AutoCAD MEP 2014 (AMEP 2014).
AutoCAD Architecture 2013 (ACA 2013) or AutoCAD MEP 2013 (AMEP 2013).
AutoCAD Architecture 2012 (ACA 2012) or AutoCAD MEP 2012 (AMEP 2012).
AutoCAD Architecture 2011 (ACA 2011) or AutoCAD MEP
2011 (AMEP 2011).
AutoCAD Architecture 2010 (ACA 2010) or AutoCAD MEP 2010 (AMEP 2010).
AutoCAD Architecture 2009 (ACA 2009) or AutoCAD MEP
2009 (AMEP 2009).
AutoCAD Architecture 2008 (ACA 2008) or AutoCAD MEP
2008 (AMEP 2008).
Both 32-bit and 64-bit is supported.
Any database like Access (MDB or .accdb) or SQL Server that can be connected with
dbConnect within AutoCAD is supported. Other examples are
SQL Server Express, Oracle,
ODBC, etc. AutoCAD 64-bit does only support Access 2010/2013 64-bit or the free
Microsoft Office 12.0 Access Database Engine OLE DB Provider/Microsoft
Access Database Engine 2010 Redistributable.
Excel is not supported as it is not a real database.
If you run 64bit AutoCAD you cannot have 32bit Office installed and also
connect to MS Access database.
Any operating system that can run the above is supported
from Windows XP, Windows Vista, Windows 7, Window 8 and Windows 8.1.
75 USD for one license or less depending on the amount of licenses. When your
purchase is completed you will get an email (sent manually) typically within 24
hours with the license file.
If you have really many users that you
want to give access to this software we can discuss a discounted price based
on your particular situation. Educational discounts available.
The license is perpetual and support is included. If you have more than one
computer and you are the only user of the application one license is enough.
Available payment methods: Credit card (Visa, Master Card, American Express, Discover, Diners Club, JCB, Carte
Bleue), PayPal, Local Bank Transfer, Wire Transfer, Bankgiro, Real-time Bank Transfer,
Electronic Check (ECP), Skrill (Moneybookers), WebMoney and
Alipay (PaySafeCard, Ukash, cashU, Boleto Bancario, Boleto Bancario can be
made available upon request)
- JTB.AcaDbXMgd_17.dll (for 2009) or JTB.AcaDbXMgd_18.dll (for
2010-2012) or JTB.AcaDbXMgd_19.dll (for 2013)
- ACA_db_samples_2007.dwg or ACA_db_samples_2010.dwg or or
- ACA_db_license.txt (sent by email from JTB World upon request)
- Place the DLL file in a single local folder.
For example C:\Program
Files\JTB World\ACA_db .
- Place also the license file ACA_db_license.txt in the same
- ACA_db_samples.UDL should be placed in the Data Links folder.
The location is found easiest by using the
command OPTIONS and Files>Data Sources Location
- Place the MDB in a folder with read/write access.
The DLL needs to be loaded by your AutoCAD application and that can
be done in different ways. Use one of the following options.
- Use the command NETLOAD and select the DLL. This loads the
command in the current session only.
- Create a menu command, toolbar button, ribbon button or palette tool using CUI and
force load it before running the command.
Macro or Command string:
^c^c(command "netload" "C:/Program Files/JTB World/ACA_db/JTB.AcaDbXMgd_18.dll")
- Use one of the AutoLoad...reg files that can be provided. Double click on the file and accept
to merge to the registry. This will make sure that the commands
available whenever you run AutoCAD.
- Add the row below to your acad.lsp file so it loads automatically when
(command "netload" "C:/Program Files/JTB World/ACA_db/JTB.AcaDbXMgd_18.dll")
Prepare the database that holds information on what
properties to synchronize and where. See ACA_DB-UserManual.pdf on how
this is achieved.
Make sure there is an UDL file (data source) that points
out the location of the main database.
In the CAD program use ACADBSETTINGS command to specify
what data source to use as the main database.
Run the ACADBMAKE command to make new/existing drawing
possible to sync.
Now use either of the commands ACADBOUT or ACADBIN to
sync information into CAD or out from CAD.
The command line will show full details on if there are
any problems and what data has been synchronized.
Some further details.
- Property set data type and database data type must be compatible.
- A PSD must be linked to a single table.
- An object must not have 2 or more records linked from same db link.
- An object must not have 2 or more records linked from different db
links referencing same table.
- All automatic properties are considered as read-only. Such
properties can sync to database but cannot sync from database.
- All automatic properties are considered as
read-only. Such properties can sync to database but cannot sync from
Solution to the following error is to right click on the DLL file and
click on Unblock.
Cannot load assembly. Error details: System.IO.FileLoadException: Could
load file or assembly 'file:///C:\Users\JTB\AppData\Roaming\JTB
World\.....dll' or one of its dependencies. Operation is not
supported. (Exception from HRESULT: 0x80131515)
File name: 'file:///C:\Users\JTB\AppData\Roaming\JTB
World\....dll' ---> System.NotSupportedException: An
was made to load an assembly from a network location which would have caused
the assembly to be sandboxed in previous versions of the .NET Framework.
release of the .NET Framework does not enable CAS policy by default, so this
load may be dangerous. If this load is not intended to sandbox the assembly,
please enable the loadFromRemoteSources switch. See
http://go.microsoft.com/fwlink/?LinkId=155569 for more information.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String
codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint,
StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean
forIntrospection, Boolean suppressSecurityChecks)
assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile,
Evidence securityEvidence, Byte hashValue, AssemblyHashAlgorithm
hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks,
at System.Reflection.Assembly.LoadFrom(String assemblyFile)
at Autodesk.AutoCAD.Runtime.ExtensionLoader.Load(String fileName)
See also more details here:
Solution to System.IO.FileLoadException Could not load file or assembly
2012-09-16 - version 4.0
- Support for ACA 2013.
- Support for 64-bit.
- IsDimensionInNumericFormat added to table JTBW_Properties. If
yes, then dimensions are in numeric format. If no, then dimensions are in
text format (feet & inches).
2009-10-15 - version 3.0
- Now with support for full 2-way synchronization of
data both from and to ACA respectively database.
- No need to use dbConnect to link object by object.
- More features suppored for ACA 2010 like manual
property set variants (Integer, List, Real, Text and True/False) and list data types.
- 2009-03-23 - version 2.1
- Full support for AutoCAD Architecture 2010
- Support for table names with spaces or other non
- 2008-05-05 - version 2
- Several improvements under the hood
- Support for multiple database sources
- UI improvements
- Full support for AutoCAD Architecture 2009
- 2008-02-22 - version 1.1
- Support for AutoCAD Architecture 2009 beta
- The bug in ACA 2008 is fixed in ACA 2009 that cause the following
"harmless" crash message when closing AutoCAD. "AutoCAD Error Aborting -
INTERNAL ERROR: Attempt to access AecScheduleDataServices after
- 2007-12-28 - version 1
- First release for AutoCAD Architecture 2008
Screenshot from version 2.1
Some ACA_db customers
More customers are
ACA_db will help you expand and improve your BIM process.
If you want other features added feel free to contact us with your
Tags: AutoCAD Architecture add-on, AutoCAD MEP add-on, AutoCAD
Architecture app, AutoCAD MEP app, Building Information Modeling