[AccessD] Back End Bloat - Revisited

Hi Gustav

Got it.  I checked a couple of tables and it is off for them.  I've never set that switch for any table, so I'm guessing that "off" is the default position.  Looks like that feature relates to replication, and there's none of that going on with this database.

BTW, the BE that is giving me fits holds meta data related to text files containing data produced by other systems.  This same app is attached to another BE database that collects summarized data from those text files.  This second DB receives data only (no updates to records) and grows at a rate that appears closely tied to the rate at which data is added to its tables.  This leads me to think that the bloating trouble that I'm having with the meta data BE might be related to the updating of existing records that the app does.  I understand next to nothing about how Jet manages the database, but does this hunch square with the normal function of Jet?  I would have expected bloat to occur in the front end, because that's where all the code, queries, etc happen.  Why does the BE experience bloat in the sort of arrangement that I have described?

I appreciate your willingness to share your expertise with me (and all of us).

Happy New Year!

Don


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 01, 2009 2:44 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Back End Bloat - Revisited

Hi Don

Off!

/gustav

>>> Donald.A.McGillivray at sprint.com 01-01-2009 23:41 >>>
Thanks, Gustav.

Yes, I did turn off the subdatasheets.  What about row level tracking?  What are you suggesting for that?  Switch it off if it's on?

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 01, 2009 1:13 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Back End Bloat - Revisited

Hi Don

Not much to add, but did you turn subdatasheet feature off for tables not needing this feature? It is in table design view properties, while the rowlevel tracking is found on the properties of the table in data view.

/gustav



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


This e-mail may contain Sprint Nextel Company proprietary information intended for the sole use of the recipient(s). Any use by others is prohibited. If you are not the intended recipient, please contact the sender and delete all copies of the message.