Kath Pelletti
kp at sdsonline.net
Mon Jul 17 18:33:42 CDT 2006
Patricia - I doubt this is it, but I had something similiar just this month. My client's BE file blew out from 32MB to 320 MB approx. Turns out the tech staff had removed my users' permissions to update and delete from the network drive where the BE was residing. Therefore when the users closed the database, it wasn't able to compact on close. Kath ----- Original Message ----- From: O'Connor, Patricia (OTDA) To: Access Developers discussion and problem solving Sent: Tuesday, July 18, 2006 4:28 AM Subject: [AccessD] (no subject) 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com