[AccessD] Learned something new

Hi Karen and Bobby

I find it easier just to (re)create the temp database when you launch
the frontend.

/gustav

>>> cyx5 at cdc.gov 08-03-2005 13:37:58 >>>
That is a great idea.  I never thought of that.  I am going to
implement
this in my applications.  Thank you.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Tuesday, March 08, 2005 7:24 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.