Truncate table?

[JayKusch]

Evening Folk ...

have a tbl i need to truncate nightly before the next job run. Is there a "Truncate Table" command or am i only able to use the delete command. have anywhere from 1.5 to 2 milliom recs to remove and delete takes forever.

Thanks

 

[tlbroadbent]

Access doesn't have a Truncate table command. You'll have to use Delete. Or you can Drop the table and create a new table. That wil be faster than Delete. However, it may not be possible if relationships are defined. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.