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.
Step4: Testing Connection
Come Back to "Data Link Properties" and Select "Test Connection"