Cad working with Access

[panarodias]

Hi,
Does anyone knows how to link an access database with autocad?
Not using the OLE object.
Thanks.

[PJ]

Have you tried the dbconnect function. You should be able to open up a database from there. Otherwise you can do this in VBA, normally best when you want to export information from the drawing directly into a database.

I have created a vba routine that takes the handle, type of object and coordinates of the object and uploads that into an access table.

If this is the type of thing you were after then post a reply to this message and I will supply the code when I get home later.

Thanks,

[PJ]

Have you tried the dbconnect function. You should be able to open up a database from there. Otherwise you can do this in VBA, normally best when you want to export information from the drawing directly into a database.

I have created a vba routine that takes the handle, type of object and coordinates of the object and uploads that into an access table.

If this is the type of thing you were after then post a reply to this message and I will supply the code when I get home later.

Thanks,

[panarodias]

Hi PJ,
sorry took so long to answer, I was away on a trip.
I studied the DBconnection as you mentioned, and made an ODBC successfully, but the only thing I can do is to update an Cad Label when I change it in the Access table, not the other way around.
Do you know if I can do something that when I made some changes in Cad, would do the same in Access?
I think the VBA routine that you mentioned would be a great help, If its OK, please send me.
Thanks,
Alexandre

[YosSa]

AutoCAD works fine with Acces.
I have made a VBA routine which stores areas in a access dbase.

Works perfect ...