12-15-2011 11:47 AM
Have a basic question on PROC SQL-
When I run a delete query such as below:
delete from HH.hh_TEST
where Month_and_Year_of_Observation ='NOV 2011';
It only erases two entries at a time instead of all 300. It is running off an Access DB if that makes any difference.
How can I erase all 300 w/o necessary running a loop.
And why does it do this..
01-23-2012 12:37 PM
OK-I have used the the direct DIRECT_EXE = DELETE option with access 2003.
DO you lnow the provider for Access 2010?
I have the string
libname T oledb provider="Microsoft.Jet.OLEDB.4.0"
properties=('data source'='X:\X.MDB') DIRECT_EXE = DELETE but the provider is not correct for access 10-
I went online and found a different "provider- but that fails too.
01-23-2012 01:03 PM
The replacement is Microsoft.ACE.OLEDB.12.0 for access 2007/2010
from Microsoft.JET.OLEDB.4.0 for access 2003
in case you migrate up-which I don't recommend!
Need further help from the community? Please ask a new question.