AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Catalog Lookup Problems

5 REPLIES 5
Reply
Message 1 of 6
Shawnr
389 Views, 5 Replies

Catalog Lookup Problems

I have been using ACADE 2007 for a few months, I have set up my catalog file on a network to be shared. Everything has been working fine until I downloaded and installed ACADE 2007 SP2 yesterday. Now when I edit a component symbol and select catalog lookup it opens the correct table from the correct catalog but it does not display any records. Even when I checked ALL on every box it says no records found that match. If I click add record and add something it still does not display. If I open the catalog with Access the added record is there. So everything works except it doesn't display any records for me to select under catalog lookup? Any suggestions
5 REPLIES 5
Message 2 of 6
Anonymous
in reply to: Shawnr

Could you check 2 things. Fist when you go to the catalog lookup, on the
Parts Catalog dialog that appears, does the path to the database in the
title bar look correct? Also, right-click on the active project in Project
manager and select Settings. Look for the 'Active catalog lookup' line and
make sure that path is correct (you might also look at some of the other
paths in the Settings dialog just to make sure).

I am not sure what the cause might be, but I am thinking that maybe it is
just pointing to the incorrect database for some reason after installing the
service pack. This would not explain why an added record still gets added,
but it is something to look at that might help shed some light on the cause.

Steve

wrote in message news:5705160@discussion.autodesk.com...
I have been using ACADE 2007 for a few months, I have set up my catalog file
on a network to be shared. Everything has been working fine until I
downloaded and installed ACADE 2007 SP2 yesterday. Now when I edit a
component symbol and select catalog lookup it opens the correct table from
the correct catalog but it does not display any records. Even when I checked
ALL on every box it says no records found that match. If I click add record
and add something it still does not display. If I open the catalog with
Access the added record is there. So everything works except it doesn't
display any records for me to select under catalog lookup? Any suggestions
Message 3 of 6
Shawnr
in reply to: Shawnr

The path in the title bar on catalog lookup is correct, so are the paths in the project settings. I have found that if I switch to the original catalog file that came with the software it will display the records. Also if I copy some records out of a table in my catalog and paste it in a working copy of the original catalog, that table will no longer display records in catalog lookup. Is my catalog file corrupt maybe. The tables are all labeled replicated, I think someone ran some kind of backup on that network drive and after that all the tables were marked replicated. But it was working like that before installing the service pack. I think I am just gonna have to build a new catalog file.
Message 4 of 6
Anonymous
in reply to: Shawnr

If I go into my database and do replication on it, I can get the results you
are seeing. I have not tried this without SP2 installed. I have been
trying to find a way to remove the replication option, but I am not an
Access expert and have not done anything at all with replication in years
and even then it was just some playing around with it.

Maybe someone else on here would have an idea of how to remove this from the
database so that you don't need to build a new catalog file. Or maybe go
back to what they backed up, maybe it is OK.

Maybe saving to an older version of Access would work also, but it did not
seem to matter for me, but I am using Access 2007.

Steve

wrote in message news:5709946@discussion.autodesk.com...
The path in the title bar on catalog lookup is correct, so are the paths in
the project settings. I have found that if I switch to the original catalog
file that came with the software it will display the records. Also if I copy
some records out of a table in my catalog and paste it in a working copy of
the original catalog, that table will no longer display records in catalog
lookup. Is my catalog file corrupt maybe. The tables are all labeled
replicated, I think someone ran some kind of backup on that network drive
and after that all the tables were marked replicated. But it was working
like that before installing the service pack. I think I am just gonna have
to build a new catalog file.
Message 5 of 6
Peter_KSBE
in reply to: Shawnr

On page 22 of the attached doc you can find info on how to undo a replication for Access 2000-2002-2003.
Looks like all db's for AE are 2000 format?

Hope it helps.

Peter
Message 6 of 6
Shawnr
in reply to: Shawnr

I opened my database and right clicked each table, selected properties, and unchecked the box next to replicable and it seems to work. It adds a field called s_Guid to the tables and I don't know what that is for or what it will hurt, but the catalog lookup in AE will display the records now. I guess I am going to leave it like this for now, since it seems to work. Thanks for the help guys. Message was edited by: Shawnr

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost