Linking Autocad2k and Access with VBA

Hi all!
I'm in trouble.
I have to make a program under acad2000. That isn't a "big" problem, but i am very novice in this part of the programing. My problems are the following:
I have a database in Access with forms, tables, i have also blocks in AutoCAD. My job is linking the object in acad and the blocks in a access database.
How can i do the following with the help of vba:
I want see a list in acad2000, this list will be the one of the access databases table (example apple, pear, orange), and if i choose one item from the list that calls a block from what i made before it and insert it at the modelspace some x,y,z co-ordinates.
If somebody has it in a program and can send it that would be great and helpfull.

Pls help
Many thanks.

 

You will find many topics on this in the Customization Group. Also
there is a sample in the help menu. Think it was there in 2000.

 

Sorry..."Connectivity Group"

 

You will need to use one of the Microsoft data access libraries, either Data
Access Objects (DAO) or ActiveX Data Objects (ADO) from an AutoCAD VBA code
module to access the MS-Access table your information is stored in. As Paul
mentioned, AutoCAD comes with a sample showing how to do this. Take a look
in the Program Files\ACAD2000\SAMPLE\ forder for "db_samp.dwg" and
"db_samples.mdb". DAO and ADO help should be available from the main Access
help, probably under the "Programming Information" book. See if they make
any sense to you, then ask some more questions.
--
John Goodfellow
irtfnm (presently available for projects)
use john at goodfellowassoc dot com

am very novice in this part of the programing. My problems are the
following:

AutoCAD. My job is linking the object in acad and the blocks in a access
database.

databases table (example apple, pear, orange), and if i choose one item from
the list that calls a block from what i made before it and insert it at the
modelspace some x,y,z co-ordinates.

 

Thx for the help.
I will do that.