spardey wrote:
sConn = "ODBC;DSN=MS Access Database;" & _
"DBQ=C:\Program Files\Microsoft
Office\OFFICE11\SAMPLES\Northwind.mdb;" & _
"DefaultDir=C:\Program Files\Microsoft
Office\OFFICE11\SAMPLES;" & _
"DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"


"Run-time error 429
ActiveX component can't create object"

Try removing 'ODBC;' from sConn and see if that doesn't do it.


--
Dick Kusleika
MVP-Excel
www.dailydoseofexcel.com