Can Access 2003 link to an AutoCad file?

[Cumar]

I am constructing an Access 2003 database on the buildings of a community,
and use autocad 2007 to draw a building plan of each building. Through a
query in the database, I would like to link to the corresponding building
plan to be viewed/print.
Can you please help?
Best regards
Cumar

 

[Arvin Meyer [MVP]]

I am constructing an Access 2003 database on the buildings of a community,
and use autocad 2007 to draw a building plan of each building. Through a
query in the database, I would like to link to the corresponding building
plan to be viewed/print.
Can you please help?
Best regards
Cumar

Perhaps indirectly. VBA, unless AutoCAD changed recently is still the
programming language for both Office (including Access) and AutoCAD. AutoCAD
also can output files in Excel format. Access can read Excel tables. So, if
AutoCAD can link to the file that it creates in Excel, you should be able to
link (but read-only, not update) from Access.

 

[a a r o n . k e m p f]

you should just be able to copy and paste ole objects from one to the
other-- at least it works that away from Visio for me

 

[Arvin Meyer [MVP]]

Sorry that I misread your question. If you store the path to the drawing,
you can open AutoCAD to the drawing. I have a document management sample app
that you could modify easily to collect, store and open your AutoCAD
documents:

http://www.datastrat.com/Download/DocMgr_2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com