StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The answer depend on the technology used from the client which use MDB. There are different tracing settings which you can configure in HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\ODBC <a href="http://office.microsoft.com/en-us/access/HP010321641033.aspx" rel="nofollow noreferrer">http://office.microsoft.com/en-us/access/HP010321641033.aspx</a>. If you use OLEDB to access MDB from SQL Server you can use DBCC TRACEON (see <a href="http://msdn.microsoft.com/en-us/library/ms187329.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms187329.aspx</a>). I can continue, but before all you should exactly define which interface you use to access MDB.</p> <p>MDB is a file without any active components, so the tracing can makes not MDB itself, but the DB interface only.</p> <p><strong>UPDATED</strong>: Because use use DAO (Jet Engine) and OLE DB from VB I recommend you create JETSHOWPLAN regisry key with the "ON" value under HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\JET\4.0\Engines\Debug (Debug subkey you have to create). This key described for example in <a href="https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-5064388.html" rel="nofollow noreferrer">https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-5064388.html</a>, <a href="http://msdn.microsoft.com/en-us/library/aa188211%28office.10%29.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa188211%28office.10%29.aspx</a> and corresponds to <a href="http://support.microsoft.com/kb/252883/en" rel="nofollow noreferrer">http://support.microsoft.com/kb/252883/en</a> allow trace OLE DB queries. If this output will be not enough for you you can additionally use TraceSQLMode and TraceODBCAPI from HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\ODBC. In my practice JETSHOWPLAN gives perfect information for me. See also SHOWPLAN commend.</p> <p><strong>UPDATED 2</strong>: For more recent version of Access (like Access 2007) use key like <code>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines</code>. The tool ShowplanCapturer (see <a href="http://www.mosstools.de/index.php?option=com_content&view=article&id=54&Item%20%20id=57" rel="nofollow noreferrer">http://www.mosstools.de/index.php?option=com_content&view=article&id=54&Item%20%20id=57</a>, to download <a href="http://www.mosstools.de/download/showplan_v9.zip" rel="nofollow noreferrer">http://www.mosstools.de/download/showplan_v9.zip</a> also in english) can be also helpful for you.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload