JTB ACAD_db

About

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.

Download

Installer for version 4.3.0: JTB ACAD_db_4.3.0.zip.

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.

System requirements

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, AutoCAD 2021, AutoCAD 2022, AutoCAD 2023. 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, Windows 10 and Windows 11.

JTB World is an Autodesk Authorised Developer

Purchase

New license: 150 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: 75 USD for one license or less depending on the quantity of licenses. If you purchased on or after April 25, 2020 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. Support and upgrades is included for a minimum of 2 years after purchase. 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.

If your company is tax exempt note that BlueSnap does not currently offer a way to prevent tax from being charged on orders. We need a copy of the tax exempt certificate to refund the tax if already paid.

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

Documentation

Documentation for version 4.0.5 here.

Setup procedure

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

See activation instructions here: JTB World Apps Licensing.

Usage

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.

Version History

2022-04-25 - version 4.3.0
- Added support for AutoCAD 2023
2021-07-09 - version 4.2.0
- Remove messages about uninstallation in very-silent installation mode.
2021-04-13 - version 4.1.2
- Added support for AutoCAD 2022
2020-07-24 - version 4.1.1
- Upgraded to License 4.3
2020-05-09 - version 4.1.0
- Added support for AutoCAD 2021
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.