Rocky Smolin
rockysmolin at bchacc.com
Tue Jan 5 08:23:39 CST 2010
And yet a tight loop in code through the table names and a db.Execute "Delete * FROM " & strTableName would be pretty fast to write and run. Don't know if Access 02 supports DAO. But you wouldn't have to use A2 - you could use something more moderne. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of johncliviger at aol.com Sent: Tuesday, January 05, 2010 1:39 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Access FE: SQL BE Happy New Year to all, A client has a Access 02 FE with an SQL 2005 BE. He wants to clear out all the old data. There are over 150 tables. What would you recommend as a quick method to remove the Data? Using "Delete * From tablename" seems a bit clunky john cliviger -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com