[AccessD] Access FE: SQL BE

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




More information about the AccessD mailing list