• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

AutoCAD .dwg files as Access '95 OLE

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
pamgffx
Asked:
pamgffx
  • 2
1 Solution
 
mecneCommented:
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
 
pamgffxAuthor Commented:
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
 
mecneCommented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now