Solved

AutoCAD .dwg files as Access '95 OLE

Posted on 1997-08-03
3
574 Views
Last Modified: 2006-11-17
I'm trying to link AutoCAD .dwg files within a table
under Access '95.  Most of these files will be read-only
and are marked with that attribute.
When I try to link a file (Insert Object, Link, Browse)
and select a file, my system locks up.   I CTL-ALT-DEL and
kill the AutoCAD alert task, then control returns to my
Access screen.   When I once again (Insert, Link, Browse)
and select the same file, it works beautifully.   But I
don't know why.   Has anyone else had problems linking files?
I don't seem to have this problem with Excel or Word files.
Just AutoCAD.
Thanks for any and all help!
0
Comment
Question by:pamgffx
  • 2
3 Comments
 

Accepted Solution

by:
mecne earned 200 total points
ID: 1955496
Linking files is a real problem area. I would not recommend it unless you have very fast machines and lots of patience. Linked files can take forever to syncronize. If you have the disk space, embed the files. This way you can update them with a double click, but they will be part of your Access file. As to your particular question about DWG files, you did not list what version of AutoCad you are using but I would imagine your problem is AutoCad. I have had quite a few problems with AutoCad working with other software. AutoCad is VERY picky about reading files from other programs. I would suggest using the latest version of AutoCad (v-14) as this is much more "Windows" friendly or going to a program such as TurboCad which is Windows based and uses True-Type fonts. TurboCad (www.turbocad.com) is only $100 and I use it quite a bit with other Windows software. It will save files in Native DWG if they are fully exploded. If you are tying a database to your Cad drawings, the Pro version of TurboCad($250) contains a built in Database engine and will output Excel and Access files. The first version is still a little buggy but may work for you situation (they offer a 60 day return policy). Also look for the "Phoenix" Cad program from Visio (www.visio.com)later this year. It will write native DWG and should tie in well with Microsoft products. Hope this helps.
0
 

Author Comment

by:pamgffx
ID: 1955497
I appreciate the help.   I'm going to try this on a larger,
faster machine and see if it makes much of a difference.
The user won't want to change from AutoCAD, but perhaps I
can talk them into the newer version (they're currently using
version r13).   Good to know someone else has tried the same
sort of application.   Thanks!
0
 

Expert Comment

by:mecne
ID: 1955498
If you continue to have problems with DWG files with your application, you might try saving your AutoCad files as WMF. (Windows Meta Files). It probably would not be of any benefit to link this type of file as it is not a native format, but this file type may be smaller and work better with Windows. For a real small file size, you could use a graphics converter to change the  WMF files to JPEG's. Hope this helps.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question