I assume you are trying to create a QUERY or VIEW in ACCESS; if so, try this:

Cnn="DRIVER={MICROSOFT ACCESS DRIVER
(*.MDB)};DBQ=C:\OURFILES\AJAY\HIER\HIER.MDB;"
Sql="CREATE VIEW AJAY AS SELECT * FROM FILESYSTEM WHERE AMOUNT<1000;"
Set ADOC = CreateObject("'ADODB.Connection")
ADOC.Open Cnn
ADOC.Execute Sql
ADOC.Close
Set ADOC = Nothing

**Change the SQLand DBQ as required**

"quartz" wrote:

I am using Windows XP with Office 2003; ADO 2.7.

In the past, I have always only need to return a recordset from Access so I
know how to do that. But, now I need to send a SQL command to Access using
ADO.

Can someone please post example ADO to do that? I use an ODBC-type
connection string as follows:

ConnectionString = "DRIVER={MICROSOFT ACCESS DRIVER (*.MDB)};DBQ=" &
argFullName & ";USER ID=;PASSWORD=;"

Thanks much in advance.