I have a problem with a database created in MS Access. Vlookup function not working properly.
There are certain fields that the Acad "freezes" and stops operating. Autocad not indicate an error and only close the application.
With the previous version of AutoCAD 2009, works fine.
What could be wrong? I have Autocad Electrical 2013 SP1
If the issue also happens in the AutoCAD Electrical 2013 RTM version?
And is it possible for you to send us the test database file to reproduce the issue? you can remove most of the data in the database, and just remain limited records, but can still reproduce the issue.
You can directly send the file to me by firstname.lastname@example.org
If AutoCAD Electrical freezes or locks up when performing a catalog lookup, it could have to do with some table fields being empty in the database default_cat.mdb. At the very least, fields 1, 2, 4, and 5 must be populated for all records. We've seen this lockup issue caused by table records which don't conform to this. Once the lockup occurs, even switching back to the default catalog database (MDB) file won't correct the freezing behavior.
If you've confirmed that another Windows user works fine on the same workstation, then try the following:
The deleted registry key will be rebuilt and catalog lookup functionality should return to normal.
I made each of the steps, but not fixed.
What I have found is that by using the new version 2013, was detected to be "frozen" in some sections. Giving revision was detected to be re-formatted headers in the database works with this new version.
But it works fine one time, and the next time that I open the base with a VLOOKUP "freezes" the acad.. and does "corrupt" the database ..
any other ideas?
I attach the compact version of the database with the explain of the case..
Thanks a lot!
Last entry moved to new thread
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.
The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.
Upgrading to a 2015 product? Make sure to check these out 1st!