Have you reloaded your database? Any time you make structure changes, R:base creates a copy of your table and then removes it. If you don't do a reload, those temporary tables will still be taking up space in the database.
Troy ===== Original Message from [EMAIL PROTECTED] at 5/02/02 11:46 pm >Recently, I added constraints to many of my tables to prevent users from >leaving important dates, dollars, and quantities blank (not null >constraint). Although I can do this in forms, they have access to these >same tables using browse/edit. > >But... I noticed that at a customer this week, a table which had a file 2 >size of 12mb and file 3 size of 8mb, jumped to 17mb for file 3 after the >constraints where added??!!! > >This doesn't seem like very good design. Any suggestions? > >TIA, > >Dennis >***** > > >Dennis Fleming >IISCO >http://www.TheBestCMMS.com >Phone: 570 775-7593 >Fax: 570 775-9797 >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
