topic Re: Linking AutoCAD object to Access Database in VBA Forum

Linking AutoCAD object to Access Database

Anonymous — Mon, 12 Sep 2005 11:39:15 GMT

Hey everyone. I was wondering if anyone knows where there's a good online tutorial about how to link AutoCAD objects to a Microsoft Access database. Tried reading the ones on this Autodesk website in the How-To section, but the material didn't get as far as explaining exactly how to do what I wanted to do, which is to have every block in a drawing linked to an entry in MS Access. Thanks!

Re: Linking AutoCAD object to Access Database

Anonymous — Tue, 13 Sep 2005 12:48:50 GMT

Hi jboecker,

Since no one has replied, I thought just throw this out your way. I'm not real sure exactly what you are trying to accomplish, but give this link a try and see if helps you out any: http://www.tek-tips.com/faqs.cfm?fid=5800.

HTH
Todd

Re: Linking AutoCAD object to Access Database

Anonymous — Tue, 13 Sep 2005 13:23:45 GMT

Check out Jon's web site. He's got some good info regarding DBs and
AutoCAD.

http://www.fleming-group.com/ConsultingIndex.htm

Just out of curiosity, why do you want to link every block to an entry in
Access??

--
It takes a big man to cry, but it takes a bigger man to laugh at that man.

wrote in message news:4953039@discussion.autodesk.com...
Hey everyone. I was wondering if anyone knows where there's a good online
tutorial about how to link AutoCAD objects to a Microsoft Access database.
Tried reading the ones on this Autodesk website in the How-To section, but
the material didn't get as far as explaining exactly how to do what I wanted
to do, which is to have every block in a drawing linked to an entry in MS
Access. Thanks!

Re: Linking AutoCAD object to Access Database

Anonymous — Tue, 13 Sep 2005 13:25:13 GMT

Oh... and don't forget to check out the Connectivity NG.

--
It takes a big man to cry, but it takes a bigger man to laugh at that man.

"Matt W" wrote in message
news:4954372@discussion.autodesk.com...
Check out Jon's web site. He's got some good info regarding DBs and
AutoCAD.

http://www.fleming-group.com/ConsultingIndex.htm

Just out of curiosity, why do you want to link every block to an entry in
Access??

--
It takes a big man to cry, but it takes a bigger man to laugh at that man.

wrote in message news:4953039@discussion.autodesk.com...
Hey everyone. I was wondering if anyone knows where there's a good online
tutorial about how to link AutoCAD objects to a Microsoft Access database.
Tried reading the ones on this Autodesk website in the How-To section, but
the material didn't get as far as explaining exactly how to do what I wanted
to do, which is to have every block in a drawing linked to an entry in MS
Access. Thanks!

Re: Linking AutoCAD object to Access Database

Anonymous — Tue, 13 Sep 2005 15:11:58 GMT

The reason I want to do this is because I'm trying to link some AutoCAD drawings of power systems to a program that simulates the power flow on the systems. The simulator program works with Access databases. The ultimate goal is to make VBA code such that when a new device is drawn on the AutoCAD drawing, it's automatically added to the simulator's database. Also, when a new device is added into the simulator program's database manually, it should show up on the AutoCAD drawing. Craziness, but I like doing this kind of thing. Thanks for all the help so far!

Re: Linking AutoCAD object to Access Database

Anonymous — Tue, 13 Sep 2005 17:25:28 GMT

You will need to look at the Connectivity Automation Object (CAO) - acad_car.chm

There's a sample vb/a application here:
C:\Program Files\Autodesk Map 3D 2006\Sample\Database Connectivity\CAO

Scott

Re: Linking AutoCAD object to Access Database

Anonymous — Wed, 14 Sep 2005 11:05:26 GMT

I don't know of much in the way of on-line tutorials, but "AutoCAD Database
Connectivity", Scott McFarlane, ISBN 0766816400 does a good job of covering the
facilities that are built-in to AutoCAD. Alas, the CAO stuff is out of date;
if you want to use the built-in AutoCAD linking facility and do this linking
from one of your programs, CAO is how you do it. But the book is well worth it
even without the CAO stuff.

In addition to any replies you might receive or already received, you may find
more information or responses by posting future connectivity related questions
in the following discussion group:

Web browser: <>
Newsreader: <>

--
jrf
Autodesk Discussion Group Facilitator
Please do not email questions unless you wish to hire my services

> Hey everyone. I was wondering if anyone knows where there's a good
> online tutorial
> about how to link AutoCAD objects to a Microsoft
> Access database. Tried reading the
> ones on this Autodesk website
> in the How-To section, but the material didn't get as
> far as
> explaining exactly how to do what I wanted to do, which is to have
> every
> block in a drawing linked to an entry in MS Access. Thanks!