Some help please! I am using an Access 97 database
    Set cnCODE = New ADODB.Connection
    strTemp = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=False;Data Source=" & "C:\Current.mdb"
    cnCODE.Open strTemp
    ....
    cnCODE.Execute "DELETE * FROM Container WHERE PrintOrder=" &
Str(selectedI)
When I reach this line I get "Syntax error in FROM clause"

However, the following works perfectly
    Set cnCODE = New ADODB.Connection
    strTemp = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security
Info=False;Data Source=" & "C:\Current.mdb"
    cnCODE.Open strTemp
    ....
    cnCODE.Execute "DELETE * FROM Container WHERE PrintOrder=" &
Str(selectedI)

My client's machine has Access 2000 and will not allow the connection to my
Access 97 databases with Microsoft.Jet.OLEDB.3.51.
--
Bill Ringbom

Bill,
Your SQL DELETE statement doesn't look correct.  There is no "*" after the
keyword DELETE

Try this:
DELETE FROM table-name [WHERE search-condition]
http://msdn.microsoft.com/library/psdk/dasdk/odch6rcj.htm

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com

Bill, Carl is correct. Access2000, SQL and Oracle do not allow the asterisks
in a DELETE statement.

--

Kent Prokopy