Solved

AutoCAD .dwg files as Access '95 OLE

Posted on 1997-08-03
3
589 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 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