Mark A Matte
markamatte at hotmail.com
Fri Jan 2 10:07:40 CST 2009
Don, I saw where you mentioned the FE was accessed via terminal server...and that it was only "1 app"......How many users might be using the FE at the same time? Mark ---------------------------------------- > From: Donald.A.McGillivray at sprint.com > To: accessd at databaseadvisors.com > Date: Thu, 1 Jan 2009 23:47:13 -0600 > Subject: Re: [AccessD] Back End Bloat - Revisited > > Dunno, John. > > I suppose that our IT overlords would prefer that we be using something other than Access. SQL server is on the list of approved alternatives, but I don't know about Express. > > Will that integrate pretty seamlessly with my Access front end? What's the learning curve like for somebody whose experience with databases is pretty much limited to working with Access? > > Don > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Thursday, January 01, 2009 7:39 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Back End Bloat - Revisited > > Any chance you could just move this BE to SQL Server Express? > > John W. Colby > www.ColbyConsulting.com > > > McGillivray, Don [IT] wrote: >> 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. >> >> > -- > 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. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ It’s the same Hotmail®. If by “same” you mean up to 70% faster. http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008