[AccessD] Learned something new

John W. Colby jwcolby at colbyconsulting.com
Tue Mar 8 08:49:49 CST 2005


Steve, that is certainly possible to do.  If you set up your systems such
that the FE is downloaded to the workstation daily so that users get the
latest version whenever fixes are applied, then you no longer need to worry
about bloating since the FE isn't around long enough to bloat.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Capistrant
Sent: Tuesday, March 08, 2005 9:41 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Learned something new


What is your work database?  A separate dedicated to handling temp tables?
Does your FE have permanent links to permanent tables in that work db?  Does
your FE's linking tool manage two sets of links -- to the BE and the WorkDb?

Steve Capistrant
scapistrant at symphonyinfo.com
Symphony Information Services
7308 Aspen Lane North, Suite 132
Brooklyn Park, MN  55428
763-391-7400
www.symphonyinfo.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Tuesday, March 08, 2005 6:30 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Learned something new

I always use a "work" database, that is separate from the FE, but in the
same location.  I then compact it upon exiting the application.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen
Sent: Tuesday, March 08, 2005 6:46 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Learned something new


I use temp tables for similar purposes, but they bloat the database a bit,
so I code it in to compact the puppy.

-- 
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