[AccessD] (no subject)

Patricia,

This may not even be related...but do you do any wild card searches against 
fields in the linked tables?

Mark A. Matte


>From: "O'Connor, Patricia (OTDA)" <Patricia.O'Connor at otda.state.ny.us>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: [AccessD] (no subject)
>Date: Mon, 17 Jul 2006 14:28:54 -0400
>
>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