O'Connor, Patricia (OTDA)
Patricia.O'Connor at otda.state.ny.us
Mon Jul 17 13:28:54 CDT 2006
What would cause the sizes of Access 2k mdb to increase humongously all of a sudden? I have many mdbs of which all have links to oracle tables but also have internal access tables included. For example I have one that is about 4 months old created on 04/04/2006 is 4,508KB. I copied the one from April today and recreated a table that actually has fewer records than the April table. This Mdb is 41,736KB. So I tried to recreate it from scratch and it still is like 32,000kb Another totally different one I created on July 05, 2006 which has more tables and data is 3,508KB. But there are two others that are similar in nature and huge 195,528. There does not seem to be a specific date when this started to happen Thanks ************************************************** * Patricia O'Connor * Associate Computer Programmer Analyst * OTDA - BDMA * (W) mailto:Patricia.O'Connor at otda.state.ny.us * (w) mailto:aa1160 at nysemail.state.ny.us ************************************************** -------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.