PRB: Prepare Command with Nonexistent Table Returns Success with Jet OLEDB Provider

When ICommandPrepare::Prepare is called from a Command object on a nonexistent table, it returns an HRESULT of S_OK instead of DB_E_ERRORSINCOMMAND(0x80040E14) or DB_E_NOTABLE (0x80040e37). This behavior occurs with the Jet OLE DB Provider when calling ICommandPrepare::Prepare on a query that contains a table that does not exist.

When preparing a command that contains a nonexistent table, other OLE DB providers may return either DB_E_ERRORSINCOMMAND or DB_E_NOTABLE. With the Jet OLE DB provider, ICommandPrepare returns S_OK when the table in the command does not exist. The Jet Provider returns DB_E_NOTABLE when you actually try to execute the command by calling ICommand::Execute.