Hi,
Is it possible to fire a "Truncate <table>" from VBA (access2003) into SQL server ?
Special considerations ?
Thanks
ADeziis example is solid and spot on I throw this into the pot for no other than your interest level of potential difference in method of execution from the 'Access' side creating a temporary querydef setting an ODBC connection string to the server and then executing the .SQL property of simply.
TRUNCATE TABLE dbo.tblBlah
has the same effect but 'does' rely on ODBC connectivity so for me has more overhead but does NOT need a specific stored procedure. Depends on your design flavour.
Personally I keep work server side so I'd go with ADezii on the actual way to go on this (as your stored procedure could then go on to account for elements such as why the table was truncated and maybe fire the reasons off to another audit system all from within the same procedure etc etc
Jim :)