[AccessD] Access FE: SQL BE

Put this in a loop in code.

Do you need assistance in doing that?

John W. Colby
www.ColbyConsulting.com


Simon Bamber wrote:
> In the past I have stepped through each table and truncated.
> 
> Assuming your table is called tblData the truncate statement would be...
> 
> 	TRUNCATE TABLE tblData
> 
> Simon Bamber
> 
> 
> HIRE COMPANY OF THE YEAR 2009 
> This message, and any associated files, are intended only for the use of the message recipient and may contain information that is confidential, subject to copyright or constitute a trade secret. If you are not the message recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify the sender immediately by replying to the message and then deleting it from your computer. HSS Hire Service Group Limited may monitor email traffic data and also the content of email for the purposes of security and staff training. Any views or opinions presented are solely those of sbamber at hss.com and do not necessarily represent those of the company.
> HSS Hire Service Group is a limited company registered in England and Wales. Registered number: 644490.
> Registered office: 25 Willow Lane, Mitcham, Surrey, CR4 4TS, United Kingdom.
>  
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> johncliviger at aol.com
> Sent: 05 January 2010 09:39
> 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