Re: [PEDA] Database maxed !
Alfonso, It may not be all that bad, they store the documents PCB etc, as binary blocks within the ddb file, just for storage. If you would like to have a look the password is: Manteghulteir All the searching etc would be done in ram using there own system not using the jet engine. DXP has dropped the database system and just stores the files on disk as any normal file, one file per document. Darren Moore > -Original Message- > From: Alfonso Baz [mailto:[EMAIL PROTECTED]] > > Sorry about this late reply > > Thanks Brad > > I am a programmer and I wasn't aware that protel was using > ODBC to access > "access" db's and quite frankly I'm shocked... > > It appears to be an access 97 db (I don't know what they're > using now in > DXP) and considering the performance penalties that software > has to pay for > using ODBC (as it is a set of generic functions that can be > used to access > odbc compliant databases) I am at a loss as to why they' ve taken this > route. > Access 97 used what was known as DAO (data access objects > which is the "Jet" > engine) and it contained functions (DAO350.dll) specific to > this type of > data base, it contained a heap of dao specific functions which made > searching, traversing and manipulating records and db's a > breeze. MS now > uses what's known as ADO(activeX data objects or OLE db) which is an > expansion of the ODBC ideology with the addition of OLE. > > In the DAO development kit it advises against using ODBC as > it's access > speed to the db as half that of DAO. > I tried running complicated SQL statements using DAO, ODBC > and ADO against a > DAO database and DAO beat them all by a difference of "Minutes!!" > > Perhaps I shouldn't be shocked... after all these are ppl who > are using > Delphi, and one only has to look at how they search for > library components > in their databases in 99SE. If they had any idea about > databases they would > connect to there dbb's and run an sql statement against the > db and produce a > list of matches in 1/10th the time it takes that search > function of theirs. > > I hope I haven't upset to many people with my rhetoric 8-) > > Alfonso Baz * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Sorry about this late reply Thanks Brad I am a programmer and I wasn't aware that protel was using ODBC to access "access" db's and quite frankly I'm shocked... It appears to be an access 97 db (I don't know what they're using now in DXP) and considering the performance penalties that software has to pay for using ODBC (as it is a set of generic functions that can be used to access odbc compliant databases) I am at a loss as to why they' ve taken this route. Access 97 used what was known as DAO (data access objects which is the "Jet" engine) and it contained functions (DAO350.dll) specific to this type of data base, it contained a heap of dao specific functions which made searching, traversing and manipulating records and db's a breeze. MS now uses what's known as ADO(activeX data objects or OLE db) which is an expansion of the ODBC ideology with the addition of OLE. In the DAO development kit it advises against using ODBC as it's access speed to the db as half that of DAO. I tried running complicated SQL statements using DAO, ODBC and ADO against a DAO database and DAO beat them all by a difference of "Minutes!!" Perhaps I shouldn't be shocked... after all these are ppl who are using Delphi, and one only has to look at how they search for library components in their databases in 99SE. If they had any idea about databases they would connect to there dbb's and run an sql statement against the db and produce a list of matches in 1/10th the time it takes that search function of theirs. I hope I haven't upset to many people with my rhetoric 8-) Alfonso Baz - Original Message - From: "Brad Velander" <[EMAIL PROTECTED]> To: "'Protel EDA Forum'" <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 7:09 AM Subject: Re: [PEDA] Database maxed ! > Alfonso, > I am not a programmer but I will try to explain. Protel's database > uses Microsoft Jet Database technology. It also uses ODBC functions and > capabilities. This is why we sometimes see ODBC errors. It is not because of > any file extension reassignments. It is the internal functions of the Protel > DDB database system, at it's core it is a Microsoft database storing Protel > files. > > Sincerely, > Brad Velander. > > Lead PCB Designer > Norsat International Inc. > Microwave Products > Tel (604) 292-9089 (direct line) > Fax (604) 292-9010 > email: [EMAIL PROTECTED] > http://www.norsat.com > Norsat's Microwave Products Division has now achieved ISO 9001:2000 > certification > > > > > -Original Message- > > From: Alfonso Baz [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 08, 2002 1:38 PM > > To: Protel EDA Forum > > Subject: Re: [PEDA] Database maxed ! > > > > > > > > I'm somewhat curious about the error message you are getting > > > > > Now I'm getting this error when I try to save all: > > > > > > [Microsoft][ODBC Microsoft Access Driver] Database has > > > reached maximum size. > > > > The fact that the error message is mentioning ODBC makes me > > think that your > > administrator has set up protels *.ddb database (renamed > > access database > > extension (*.mdb)) in the odbc "Data sources" applet in the "Control > > Panel->Administrative Tools" folder... > > > > If this is the case then perhaps you might want to get in > > touch with the sys > > admin and see if they've put a limit on the database size. > > > > The reason I'm suggesting this is because unless the database has been > > assigned to ODBC, it shouldn't be using ODBC at all! > > > > ODBC = Open Data Base Connectivity is used for sharing a > > database with other > > apps that are not designed to specifically use that > > database's interface. > > For example using ODBC you can acces "DBase" database's with Microsoft > > Acces... but if the Dbase database is password protected then > > you are going > > to need that password in ms access. > > > > Since protel's ddb file is password protected by the protel > > app, using ODBC > > is a waste of time since if you wanted to acces the dbb's > > data with another > > application using odbc you wouldn't be able to get acces to it. > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Alfonso, I am not a programmer but I will try to explain. Protel's database uses Microsoft Jet Database technology. It also uses ODBC functions and capabilities. This is why we sometimes see ODBC errors. It is not because of any file extension reassignments. It is the internal functions of the Protel DDB database system, at it's core it is a Microsoft database storing Protel files. Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com Norsat's Microwave Products Division has now achieved ISO 9001:2000 certification > -Original Message- > From: Alfonso Baz [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 1:38 PM > To: Protel EDA Forum > Subject: Re: [PEDA] Database maxed ! > > > > I'm somewhat curious about the error message you are getting > > > Now I'm getting this error when I try to save all: > > > > [Microsoft][ODBC Microsoft Access Driver] Database has > > reached maximum size. > > The fact that the error message is mentioning ODBC makes me > think that your > administrator has set up protels *.ddb database (renamed > access database > extension (*.mdb)) in the odbc "Data sources" applet in the "Control > Panel->Administrative Tools" folder... > > If this is the case then perhaps you might want to get in > touch with the sys > admin and see if they've put a limit on the database size. > > The reason I'm suggesting this is because unless the database has been > assigned to ODBC, it shouldn't be using ODBC at all! > > ODBC = Open Data Base Connectivity is used for sharing a > database with other > apps that are not designed to specifically use that > database's interface. > For example using ODBC you can acces "DBase" database's with Microsoft > Acces... but if the Dbase database is password protected then > you are going > to need that password in ms access. > > Since protel's ddb file is password protected by the protel > app, using ODBC > is a waste of time since if you wanted to acces the dbb's > data with another > application using odbc you wouldn't be able to get acces to it. > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed: Update
Terry said: I would export all the files in the database to files and start using a file system database. No more Access errors guaranteed and probably reduced load/save times. *** You know, when I first started with Protel I used a file system instead of a database, and then there was something that wouldn't work with files that would work with data- bases, so I switched. I can't exactly remember what it was. Seems like it had something to do with library access. Thanks for responding, Miker * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
I'm somewhat curious about the error message you are getting > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. The fact that the error message is mentioning ODBC makes me think that your administrator has set up protels *.ddb database (renamed access database extension (*.mdb)) in the odbc "Data sources" applet in the "Control Panel->Administrative Tools" folder... If this is the case then perhaps you might want to get in touch with the sys admin and see if they've put a limit on the database size. The reason I'm suggesting this is because unless the database has been assigned to ODBC, it shouldn't be using ODBC at all! ODBC = Open Data Base Connectivity is used for sharing a database with other apps that are not designed to specifically use that database's interface. For example using ODBC you can acces "DBase" database's with Microsoft Acces... but if the Dbase database is password protected then you are going to need that password in ms access. Since protel's ddb file is password protected by the protel app, using ODBC is a waste of time since if you wanted to acces the dbb's data with another application using odbc you wouldn't be able to get acces to it. - Original Message - From: "Robison Michael R CNIN" <[EMAIL PROTECTED]> To: "'Protel EDA Forum'" <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 12:22 AM Subject: [PEDA] Database maxed ! > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed: Final Status
MikeR, as someone else suggested but in different context, have a look in C:\program files\design explorer99se\backup\ and you might find a later version of your board. Just a punt in the dark. Regards, Brendon. "Robison Michael R CNIN" To: "'Protel EDA Forum'" navy.mil>cc: Subject: Re: [PEDA] Database maxed: Final Status 09/10/02 09:01 am Please respond to "Protel EDA Forum" Thanks to all who posted. I exported out all the files I needed and closed the DDB. I then reopened it successfully and I had lost about 3 hours work on the PCB, which I don't consider a serious loss. I haven't checked, but I assume I am working with a DDB that is about 5% of the size when it failed to save. I'll be out at the PCB West this coming March. Hope I get to see everybody. Thanks again, Miker * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed: Final Status
Thanks to all who posted. I exported out all the files I needed and closed the DDB. I then reopened it successfully and I had lost about 3 hours work on the PCB, which I don't consider a serious loss. I haven't checked, but I assume I am working with a DDB that is about 5% of the size when it failed to save. I'll be out at the PCB West this coming March. Hope I get to see everybody. Thanks again, Miker * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed: Update
On Tue, 8 Oct 2002 10:45:10 -0500, Michael Robison wrote: >Just a quick update: > >1. I have emptied the recycle bin. It only had 84KB in it. > >2. I deleted about 4 earlier versions of the PCB in the DDB. > >My feeling now is that if it would save the DDB, it would now >be down to less than 200MB. I am still getting the error. I >have 64GB left on my drive. I'm not certain yet about limits >on backup sizes. I would export all the files in the database to files and start using a file system database. No more Access errors guaranteed and probably reduced load/save times. Cheers, Terry. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed: Update
MikeR You are doing something very wrong (somewhere) if your DDB is a 1GB. I m working on a design with 2500 components, 4500 nets, 21000 nodes and the ddb is only 18 meg. Yes it is slow as molasses but still only 18 meg. MikeR if you want to send one of us your ddb , zip it , and I will be glad to look at it for you . Maybe giving us a breakdown Sch files xxxKB, pcb, xKB etc. might help Mike Reagan EDSI - Original Message - From: Robison Michael R CNIN <[EMAIL PROTECTED]> To: 'Protel EDA Forum' <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 11:45 AM Subject: Re: [PEDA] Database maxed: Update > Just a quick update: > > 1. I have emptied the recycle bin. It only had 84KB in it. > > 2. I deleted about 4 earlier versions of the PCB in the DDB. > > My feeling now is that if it would save the DDB, it would now > be down to less than 200MB. I am still getting the error. I > have 64GB left on my drive. I'm not certain yet about limits > on backup sizes. > > I will be back soon. I want to say that I REALLY APPRECIATE > ALL YOU PEOPLE HELPING ME OUT. You are all very kind. > > Thanks, Michael Robison > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Miker, Doesn't sound that ominous. Here is what I think that I would attempt. Export all of your required files from the existing DDB. Start a new blank DDB. Import your required documents into the new DDB. See how that goes for size and leave that possibly corrupted DDB behind in the dust. Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com Norsat's Microwave Products Division has now achieved ISO 9001:2000 certification > -Original Message- > From: Robison Michael R CNIN [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 8:36 AM > To: 'Protel EDA Forum' > Subject: Re: [PEDA] Database maxed ! > > > Thanks for responding. I see several responses but yours is > the first, Brad, so I'll answer what I can and then I have a > meeting and will be back in a couple hours. > > I do have the compress utility activated. I meant to say > that in the first post but forgot. Also, I'm running Windows > 2000 and Protel 99SE with the latest service pack. The > previous database was slightly over a GB. However, I would > again note that after trashing many huge mechanical layers > in order to save it now, I believe the file size it's trying > to save is probably a quarter of that size. > > Personally, I think it's filled up something dynamically and > no amount of simple paring away is going to fix it now that > it's hit the overflow button. > > The DDB has a modest 6 page schematic, and I think I have > about 4 different versions of the PCB in it. A very small > component and footprint library and that's it. The board > is 12 layers, and really pretty modest, just a few connectors > and maybe 600 traces that would break down to maybe 4000 > trace segments (does that make sense? I'm not very good at > the terminology, but I've noticed that every time you turn > a corner on a trace, it creates a new section. I learned > that when I was messing with the guard traces and trying to > assign nets to them.) > > Thanks, miker > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Michael, It looks like it is time for you to copy those remaining mechanical layers into another database, or depending on their size, 2 separate databases, and delete them from your current database and empty the trash after the delete.. This will free up a lot of room in your current database, and when you actually need to work on the Mechanical Layers, you can copy them back in, one at a time, do what you need to do, and then copy it back out to its own database, remembering to delete the file behind you and empty the trash. Mickey Mouse? Yes! But it will probably save your files. Working with limited software sometimes requires extraordinary workarounds. Also, I am just kind of cirious as t where your Mechanical Layers came from. I know that from time to time I have had to import Mechanical Layers that have been done in AutoCad, and have found that some of the the arcs and circles and other small features consist of gazillions of microscopic little segments which make for a very very large file. Is it possible that this, or something similar, is happening to you, and if so, is there anything you can do to the Mechanical Layers in AutoCad (or whatever you are using) to reduce the content of the file before you import it, or even now that it is internal to your database? JaMi Smith - Original Message - From: "Robison Michael R CNIN" <[EMAIL PROTECTED]> To: "'Protel EDA Forum'" <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 7:22 AM Subject: [PEDA] Database maxed ! > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed: Update
Just a quick update: 1. I have emptied the recycle bin. It only had 84KB in it. 2. I deleted about 4 earlier versions of the PCB in the DDB. My feeling now is that if it would save the DDB, it would now be down to less than 200MB. I am still getting the error. I have 64GB left on my drive. I'm not certain yet about limits on backup sizes. I will be back soon. I want to say that I REALLY APPRECIATE ALL YOU PEOPLE HELPING ME OUT. You are all very kind. Thanks, Michael Robison * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Thanks for responding. I see several responses but yours is the first, Brad, so I'll answer what I can and then I have a meeting and will be back in a couple hours. I do have the compress utility activated. I meant to say that in the first post but forgot. Also, I'm running Windows 2000 and Protel 99SE with the latest service pack. The previous database was slightly over a GB. However, I would again note that after trashing many huge mechanical layers in order to save it now, I believe the file size it's trying to save is probably a quarter of that size. Personally, I think it's filled up something dynamically and no amount of simple paring away is going to fix it now that it's hit the overflow button. The DDB has a modest 6 page schematic, and I think I have about 4 different versions of the PCB in it. A very small component and footprint library and that's it. The board is 12 layers, and really pretty modest, just a few connectors and maybe 600 traces that would break down to maybe 4000 trace segments (does that make sense? I'm not very good at the terminology, but I've noticed that every time you turn a corner on a trace, it creates a new section. I learned that when I was messing with the guard traces and trying to assign nets to them.) Thanks, miker Michael, sounds like either you still don't have the compress on close turned on, or possibly at a database size that big the compress function starts to fail. I might suggest that you try running the repair facility on a copy of the DDB see what that does. How big is the DDB file? What have you got inside the DDB, besides this board you were working on? How big is this board (size, layers, component, net counts)? Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com Norsat's Microwave Products Division has now achieved ISO 9001:2000 certification > -Original Message- > From: Robison Michael R CNIN [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 7:22 AM > To: 'Protel EDA Forum' > Subject: [PEDA] Database maxed ! > > > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Ensure that you've got compress on save (or something of the sort) selected. Deselect it temprarily, then click on COMPRESS manually. Once the compress has run, click the compress on save back on. The other things to check for are... Surplus documents in the deleted items bin, surplus text files (ie netlists etc) - Original Message - From: "Robison Michael R CNIN" <[EMAIL PROTECTED]> To: "'Protel EDA Forum'" <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 3:22 AM Subject: [PEDA] Database maxed ! > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison > > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
You don't need to use access, just use Protel... 1st: TAKE A BACKUP OF YOUR DATABASE, I have known this to go wrong on low memory machines. (I've no idea why this is so hidden) In the design explorer, with ALL DOCUMENTS CLOSED there is a downward pointing arrow in the menu bar at the top right. Click on this, select Design Utilities, then select compact or repair, I suggest repair, followed by compact. Select the database file you want to work on, then press OK. Database will shrink hugely. We do this almost every day. There is an option to compact on close, but if you swap design files lots, this can be annoying because of the delay. Jason. -Original Message- From: Brad Velander [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 15:37 To: 'Protel EDA Forum' Subject: Re: [PEDA] Database maxed ! Michael, sounds like either you still don't have the compress on close turned on, or possibly at a database size that big the compress function starts to fail. I might suggest that you try running the repair facility on a copy of the DDB see what that does. How big is the DDB file? What have you got inside the DDB, besides this board you were working on? How big is this board (size, layers, component, net counts)? Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com Norsat's Microwave Products Division has now achieved ISO 9001:2000 certification > -Original Message- > From: Robison Michael R CNIN [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 7:22 AM > To: 'Protel EDA Forum' > Subject: [PEDA] Database maxed ! > > > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Have you emptied the trash bin? And as Brad mentioned it would be best to experiment on a copy. David VanHorn wrote: > > > >In an effort to fix this problem, I have deleted all but > >two of the mechanical layers, and I still have the error. > >I don't understand this. I've been regularly saving all, > >and the incremental amount I added since the last "save > >all" is microscopic compared to the reduction of file size > >by deleting all those mechanical layers. > > > >Any suggestions would be appreciated. I'm getting a bit > >nervous. > > In access, there's an option to compact and repair the database. > That might help. It grows a fair bit on each manipulation. -- >>> >John M. Cardone Electro-Mechanical Dsgn. Engr. Grp. >M/S 278-100 Mechanical Engineering Section, 352 >4800 Oak Grove Dr.NASA / Jet Propulsion Laboratory >Pasadena, Ca 91109MailTo:[EMAIL PROTECTED] >Tel: 818.354.5407 Fax: 818.393.6400 >>> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Michael, Brad's answer just reminded me of another issue. Protel creates a temporary "filename.ldb" file in the same directory like the database. In there is the information who is working on the ddb. If you had a crash or I have even seen it occasionally that this ldb file wasn't deleted after closing the ddb. This makes Protel believing that somebody still is working on the design and thus compacting is not possible. So if you have closed your ddb and still have the ldb file existing you should delete the ldb. Again hope that it helps. Emanuel Brad Velander wrote: > Michael, > sounds like either you still don't have the compress on close turned > on, or possibly at a database size that big the compress function starts to > fail. I might suggest that you try running the repair facility on a copy of > the DDB see what that does. > How big is the DDB file? What have you got inside the DDB, besides > this board you were working on? How big is this board (size, layers, > component, net counts)? > > Sincerely, > Brad Velander. > > Lead PCB Designer > Norsat International Inc. > Microwave Products > Tel (604) 292-9089 (direct line) > Fax (604) 292-9010 > email: [EMAIL PROTECTED] > http://www.norsat.com > Norsat's Microwave Products Division has now achieved ISO 9001:2000 > certification > > > > >>-Original Message- >>From: Robison Michael R CNIN [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, October 08, 2002 7:22 AM >>To: 'Protel EDA Forum' >>Subject: [PEDA] Database maxed ! >> >> >>Hello, >> >>Well it looks like I'm in serious trouble now. Except for >>just a couple more mounting holes and some minor silkscreening >>on the bottom layer, I have finished this board. >> >>I posted earlier about an error with "File too big." As >>suggested, deleting a couple of the huge mechanical layers >>allowed me to save. >> >>Now I'm getting this error when I try to save all: >> >>[Microsoft][ODBC Microsoft Access Driver] Database has >>reached maximum size. >> >>In an effort to fix this problem, I have deleted all but >>two of the mechanical layers, and I still have the error. >>I don't understand this. I've been regularly saving all, >>and the incremental amount I added since the last "save >>all" is microscopic compared to the reduction of file size >>by deleting all those mechanical layers. >> >>Any suggestions would be appreciated. I'm getting a bit >>nervous. >> >>Thanks, Michael Robison > > > -- MPL AG www.mpl.ch Emanuel Zimmermann [EMAIL PROTECTED] Manager R&D Phone: +41 (0)56 483 34 34 Taefernstrasse 20 Fax: +41 (0)56 493 30 20 CH-5405 Daettwil * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Michael, Have you emptied the Trash within the database? Did you compact the database? To save your current PCB artwork you may need to export the PCB in PCB ASCII 2.8 format, then close your database with the compact while closing box ticked. Reopen the now compacted database and reimport your PCB. I have successfully worked with databases of the size of around 450 MB! A lot of trash was in it. Deleting this trash and compacting the ddb brought me to the usual 100 to 150 MB database size. Hope this helps. Emanuel Robison Michael R CNIN wrote: > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison > > > > -- MPL AG www.mpl.ch Emanuel Zimmermann [EMAIL PROTECTED] Manager R&D Phone: +41 (0)56 483 34 34 Taefernstrasse 20 Fax: +41 (0)56 493 30 20 CH-5405 Daettwil * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
08/10/2002 15:22:07, "Robison Michael R CNIN" <[EMAIL PROTECTED]> wrote: >Any suggestions would be appreciated. I'm getting a bit >nervous. >From what you posted earlier, it sounded like it was having troubles writing the backups, rather than the project itself. If you've got more than one drive (or partition), it's possible that your backups are going to a partition that's full. (my backup directory made it up to about 12 gigs, before I went and pruned old projects from it). (My current backup directory is at C:\Program Files\Design Explorer 99 SE\Backup which I suspect is the default - worth a look, at least...) Steve * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
> >In an effort to fix this problem, I have deleted all but >two of the mechanical layers, and I still have the error. >I don't understand this. I've been regularly saving all, >and the incremental amount I added since the last "save >all" is microscopic compared to the reduction of file size >by deleting all those mechanical layers. > >Any suggestions would be appreciated. I'm getting a bit >nervous. In access, there's an option to compact and repair the database. That might help. It grows a fair bit on each manipulation. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database maxed !
Michael, sounds like either you still don't have the compress on close turned on, or possibly at a database size that big the compress function starts to fail. I might suggest that you try running the repair facility on a copy of the DDB see what that does. How big is the DDB file? What have you got inside the DDB, besides this board you were working on? How big is this board (size, layers, component, net counts)? Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com Norsat's Microwave Products Division has now achieved ISO 9001:2000 certification > -Original Message- > From: Robison Michael R CNIN [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 08, 2002 7:22 AM > To: 'Protel EDA Forum' > Subject: [PEDA] Database maxed ! > > > Hello, > > Well it looks like I'm in serious trouble now. Except for > just a couple more mounting holes and some minor silkscreening > on the bottom layer, I have finished this board. > > I posted earlier about an error with "File too big." As > suggested, deleting a couple of the huge mechanical layers > allowed me to save. > > Now I'm getting this error when I try to save all: > > [Microsoft][ODBC Microsoft Access Driver] Database has > reached maximum size. > > In an effort to fix this problem, I have deleted all but > two of the mechanical layers, and I still have the error. > I don't understand this. I've been regularly saving all, > and the incremental amount I added since the last "save > all" is microscopic compared to the reduction of file size > by deleting all those mechanical layers. > > Any suggestions would be appreciated. I'm getting a bit > nervous. > > Thanks, Michael Robison * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *