O'Connor, Patricia (OTDA)
Patricia.O'Connor at otda.state.ny.us
Tue Jul 18 12:15:17 CDT 2006
Thanks for all your help. Erased rebooted and requeried with a fix and whalla normal size. Might have had something to do with patches or something. 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. -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Kath Pelletti > Sent: Monday, July 17, 2006 07:34 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] (no subject) > > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >