[AccessD] Learned something new

And using the "IN" syntax you can often do it without even linking the
tables to the FE.

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 Gustav Brock
Sent: Tuesday, March 08, 2005 7:52 AM
To: accessd at databaseadvisors.com
Subject: RE: [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.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com