NOTE - This workflow describes how to connect to CAO with MS Access database (*.mdb/*.accdb)
From AutoCAD 2020, we have retired 32-bit AutoCAD, to connect to MS Access database from 64 Bit AutoCAD, you need install 64-bit MS Access DB Engine.
(thanks for pointing out -Norman Yuan)
About version of Microsoft Office and its bitness
Please refer this blog on Microsoft
I'm using MS Access 64 Bit (MS Office 365)
Step1: Launch AutoCAD 2021
- Open the "Floor Planning" drawing from "C:\~\AutoCAD 2021\Sample\Database Connectivity\Floor Plan Sample.dwg"
- Enter "DBCONNECT"
- From DBCONNECT MANAGER, select Jet_dbSamples in "Data Sources" field.
-
Right Click and Select "Configure"
Step2: Configure DB
-
In the "Data Link Properties", select Microsoft OLE DB provider for ODBC Drivers and "NEXT."
-
In Next page, check "Use Connection String" and click Build.
-
In the "Select Data Source" window, select "Machine Data Source "page and click New.
-
Create New Data Source -> Check "User Data Source" -> Next
-
Select "Microsoft Access Driver (*.mdb,*.accdb) -> Next -> Finish
Step3: ODBC Microsoft Access Setup
- In ODBC Microsoft Access Setup window, write Data Source name of your choice.
-
Select `Database` and pick the folder where db-samples.mdb is located.
- In my example, it is located at C:\~\AutoCAD 2021\Sample\Database Connectivity.
- OK
- OK
- OK
- OK
Step4: Testing Connection
-
Come Back to "Data Link Properties" and Select "Test Connection"