v2022.3 Data Link connection Error

[Mike.M.Carlson]

I am getting the following error when trying to connect a Property Set Field to an external Access Database.mdb file via a 64bit ODBC connection. I only get this error in Property Set Definition \ Field \ Connection set up.  I can connect to the .mdb in Map3D, XDREF, etc.  Not sure what I'm doing wrong here.

[samir.rezk · Accepted solution]

Hi @Mike.M.Carlson 

With an AEC Database connection using the AutoCAD Field technology, we need to create a Microsoft Dynamic Link to configure the connection string to the Database (it's a little misleading that the dialog implies we should browse to the MDB directly!); we actually need to browse to the Dynamic Link File!

Attached is a sample UDL (Extract the ZIP) file that can be modified in Notepad, place the file alongside the database in the same folder directory as the MDB, then configure the Database path as needed.

I recorded a video to demonstrate the workflow! Hope it helps,

[Mike.M.Carlson]

Thank you @samir.rezk ...that worked for me.