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!
pamgffxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.