[AccessD] (no subject) - mdb size enlarged without reason

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
>



More information about the AccessD mailing list