[AccessD] Learned something new

Steve,

Yes, it is a separate database that is password protected.

The FE links to the work tables at the same time that it links to the BE
tables.  Due to linking problems in the past, the FE re-links to the BE and
work tables at every start up.

To handle the linking, I have two arrays of table names to link to.  Array
1, holds tables in the BE, Array 2 holds tables in the work db.  I actually
have another array that holds tables in a configuration db (legacy).

Bobby


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