Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

AutoCAD .dwg files as Access '95 OLE

Posted on 1997-08-03
3
Medium Priority
?
600 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 800 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

636 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