Re: odb file sizes
"John R. Sowden" <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Organization | American Sentry Systems, Inc. |
| Message-ID | <[email protected]> |
On Tue August 30 2005 23:42, Frank Schönheit - Sun Microsystems Germany wrote: > Hi Manolis, > > > It seems that ODB file sizes grow with time but when I create another > > odb file and copy all the tables from the old one to the new, the new > > file size is back to normal (I mean small). > > Try entering "SHUTDOWN COMPACT" in the "Tools|SQL" dialog. Afterwards, > close and re-open the database. > > > Maybe OOo 2.0 needs a "pack database" menu entry. > > Ehm - yes, but this won't get in for 2.0 anymore. > > Ciao > Frank It seems that the creators of the databaseprogram expected us to create the table perfectly in the beginning. I often have to adjust database structures in foxpro, as time goes on. I think I'll delete and recreate. -- John R. Sowden AMERICAN SENTRY SYSTEMS, INC. Residential & Commercial Alarm Service UL Listed Central Station Serving the San Francisco Bay Area Since 1967 [email protected] www.americansentry.net