Make use of AutoCAD together with an external database. Block attribute values can automatically be updated back and forth to one or many external databases. If you make changes to the attribute values they can be synchronized back to the external database or the other way around.
There are three sync methods available and can be set individually for each attribute to synchronize.
- Sync in both directions.
- Sync only from the drawing to the database.
- Sync only from the database to the drawing.
Some information might be useful to sync in both directions while other information like dimensions needs AutoCAD to be the owner. Other information like price might best be owned by the database.
Information in the title block as well as revisions is something that can be synchronized.
More flexibility and functionality than the standard AutoCAD commands EATTEXT, DATAEXTRACTION, ATTIN and ATTOUT.
ACAD_db will improve your work process and experience and will improve quality of your data and remove redundancy and conflicts of data and information.
Support for blocks in both model space and paper space and in multiple layouts. Fields of all types like Sheet Set Manager properties are supported but then sync only from drawing to the database.
Dynamic blocks are supported.
A Setup Window for the database table JTBW_AttSync is available to ease the task to create the connection between the database and the drawing.
Advance Edit Row:
Multi-line attributes are not yet supported but support for them can be added if and when needed.
Contact us to get a time limited license file for free.
Installer for version 4.0.5: JTB ACAD_db_4.0.5.exe.
Sample Access database and drawing are included with the installer.
ACAD_db_SQL.zip (114KB). Sample database for SQL Server/SQL Server Express.
ACAD_db_Oracle.zip Needed if Oracle will be used as database.
AutoCAD 2008,AutoCAD 2009, AutoCAD 2010, AutoCAD 2011,AutoCAD 2012, AutoCAD 2013, AutoCAD 2014, AutoCAD 2015, AutoCAD 2016 , AutoCAD 2017, AutoCAD 2018, AutoCAD 2019, AutoCAD 2020. Verticals with version 2008-2020 like AutoCAD Architecture, AutoCAD Civil Design, AutoCAD Civil Design 3D, AutoCAD Civil Design Professional, AutoCAD Electrical, AutoCAD Civil 3D, AutoCAD Map 3D, AutoCAD Mechanical, AutoCAD MEP, AutoCAD P&ID, AutoCAD Plant 3D, Autodesk Advance Steel and AutoCAD Structural Detailing.
Both 32-bit and 64-bit is supported.
AutoCAD LT is not and will not be 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/2016 64-bit or the free Microsoft Office 12.0 Access Database Engine OLE DB Provider/Microsoft Access Database Engine 2010 Redistributable or Microsoft Access Database Engine 2016 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. If installing Office 64-bit is not an option, some have said that it works to uninstall Office, then install the Microsoft Access Database Engine 2010 and after that install Office again. Another workaround could be to use SQL Server or SQL Server Express as backend and then MS Access 32-bit as a frontend.
Any operating system that can run the above is supported from Windows XP, Windows Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10.
Contact us if support for other CAD software is needed like BricsCAD.
JTB World is an Autodesk Authorised Developer
JTB World is an Autodesk Authorised Developer
95 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.
When your purchase is completed you will get an email with a link to the download.
Upgrade license: 45 USD for one license or less depending on the quantity of licenses. If you purchased on or after January 1, 2018 the upgrade is free of charge.
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 (as a minimum for the version available when purchased) and support is included. If you have more than one computer and you are the only user of the application one license is enough.
Click here to see how to activate the license.
Available payment methods depending on country where payment is done from: Local Bank Transfer (Canada), Wire Transfer to Canada, Interac e-Transfer, Cheque (to Canada). Via BlueSnap (Global Payment Gateway) these methods may be available (not a complete list as it is updated from time to time by BlueSnap): Credit card (Visa, Master Card, American Express, Discover, Diners Club, JCB, Carte Bleue), PayPal, Local Bank Transfer, Wire Transfer, ACH, Google Pay, UK Direct Debit, Smart Debit, Real-time Bank Transfer, Electronic Check (ECP), Apple Pay, Skrill (Moneybookers), WebMoney, Sofort, Giropay, iDeal, ENETS and Alipay (SEPA (Single Euro Payments Area) Direct Debit, PaySafeCard, Ukash, cashU, Boleto Bancario, Boleto Bancario can be made available upon request) - Refund policy
Using the JTB ACAD_db <version>.exe installer will install to program into %ProgramData%\Autodesk\ApplicationPlugins\JTBW-ACAD_db.bundle (Sample Access database and drawing in C:\ProgramData\Autodesk\ApplicationPlugins\JTB ACAD_db.bundle\Contents\)
Loading to AutoCAD will be done automatically and menu available on the Add-ins tab.
Activation: Once installed, the app is running in Trial Mode, with Trial License. Trial License will expire 15 days after first usage. Once purchased a license run JTBW_Activate_Apps, Activate the app and follow the instructions. After receiving the Activation Key you can use this app with full functionality.
Prepare the database that holds information on what block and attributes to synchronize and where.
Make sure there is an UDL file (data source) that points out the location of the main database.
In the CAD program use AcDbSettings command to specify what data source to use as the main database.
Run the AcDbMake command to make new/existing drawing possible to sync.
Now use either just open and save/close the drawing or use any of the commands AcDbOut or AcDbIn 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.
Tutorial on How to sync block attribute values with a database using ACAD_db.
For more details see the Documentation.
- 2019-08-19 - version 4.0.5
Added error handler when user adds an invalid column name.
- 2019-07-30 - version 4.0.4
Added error notification when the DBID column is missing.
Automatically add ParentBlockName and ParentBlockHandle columns.
- Updated sample database.
- 2019-07-15 - version 4.0.3
- Fixed compatibility issue with the new version of the grid.
- 2019-05-28 - version 4.0.2
- Remember last used selections in Settings window of JTBW_AttSync.
- Fully upgraded the source code and installation.
- Settings window of JTBW_AttSync.
- 2019-03-28 - version 3.0 update
- Support for AutoCAD 2020 based products.
- 2018-04-12 - version 3.0
- Support for AutoCAD 2019 based products.
- Added support for future versions of ACE OLEDB database provider
- Installer added
- Various bug fixes
- 2012-10-08 - version 2.0
- Support for AutoCAD 2013 based products.
- Support for Oracle database.
- Fixed a sync bug when NETLOAD is used.
- 2010-08-23 - version 1.1 beta
- Support for MS Access 2010 64-bit and the free Microsoft Office 12.0 Access Database Engine OLE DB Provider.
- 2009-10-26 - version 1.0
- First public release.
Contact us for any questions, wishes or comments.
ACAD_db will help you expand and improve your BIM process or information exchange between AutoCAD and an external database.