I have an access database with linked SQL Server Tables. I run an access query on the table that holds roughly 5000 records, and it takes 5 minutes. I need this to be faster! Is there a "Truncate Table" statement that I could run in Access VBA, or would it be quicker if I create a SQL Stored Proc to Truncate the Table and run the stored proc from VBA?