2018 Define Query SQL inaccessable

[dabbott]

In AutoCAD MAp 3d 2018 on a Windows 10 machine...

I have an .mdb attached.

I can see all the tables listed in the Task Pane.

I have attached a drawing.

When I go to Define Query, I set Location for "All".

I go down to SQL and it doesn't allow input. The buttons are greyed out and you can't type anything in this window.

[ChicagoLooper]

---

@dabbott wrote:

In AutoCAD MAp 3d 2018 on a Windows 10 machine...

I have an .mdb attached.

I can see all the tables listed in the Task Pane.

I have attached a drawing.

When I go to Define Query, I set Location for "All".

I go down to SQL and it doesn't allow input. The buttons are greyed out and you can't type anything in this window.

---

Take a screenshot of modelspace so it shows all the current AutoCad drawing entities. Then take another screenshot of the Explorer Tab in the Map Task Pane. Please upload both screenshots.

[dabbott]

[ChicagoLooper]

Sorry, I don’t know or work with SQL. 

If have an mbd, there are ways to ‘attach’ that mdb to your drawing, such as (1) ODBC using a DSN through your Windows or (2) ODBC by creating a UDL. 

You can read about it >>HERE<<. 

[O_Eckmann]

Hi,

is your MDB attached in drawing 037.DWG too? Because uyou can only request object available in drawing sources.

Olivier