<div>
&quot;ODBC Error 3146&quot; is insufficient info. Go to debug mode after the error and list the Errors Collection: Ctrl-G to get the immediate window, for i=0 to Errors.Count-1:? Errors(i).Number,Errors(i)<wbr />.Descripti<wbr />on:next - Errors(0) usually contains the interesting stuff.<br />

</div>


"ODBC Error 3146" is insufficient info. Go to debug mode after the error and list the Errors Collection: Ctrl-G to get the immediate window, for i=0 to Errors.Count-1:? Errors(i).Number,Errors(i).Description:next - Errors(0) usually contains the interesting stuff.


<div>
I still feel the problem may lie in a configuration option. I'll look at the lock settings. I have a feeling it is something in indexing. I don't think it's a NULL problem because all valuse are defulated to '0'. Thanks<br />

</div>


I still feel the problem may lie in a configuration option. I'll look at the lock settings. I have a feeling it is something in indexing. I don't think it's a NULL problem because all valuse are defulated to '0'. Thanks


<div>
Kuk - here are the errors<br />
&nbsp;3265 <br />
jeterr35.hlp<br />
&nbsp;5003265 <br />
DAO.Errors<br />
Item not found in this collection.<br />
<br />
Could this be a DAO problem? I run the query via a module with DAO.<br />
<br />
The error description does not make sense. I can do this at certain times and with other Indexing structures.<br />

</div>


Kuk - here are the errors
 3265
jeterr35.hlp
 5003265
DAO.Errors
Item not found in this collection.

Could this be a DAO problem? I run the query via a module with DAO.

The error description does not make sense. I can do this at certain times and with other Indexing structures.


<div>
<div class="content wysiwyg-content">
I continually receive ODBC Error 3146 in an Access97 app linked to SQL 6.5. I recently had to reinstall SQL after a struture change. I am afraid I missed some configuration option. I get this error when running INSERT INTO state ments to local temporay tables within the Access App. <br />
DB - 4GB<br />
<br />
The primary table has 1.4 million rows. 8 of 27 fileds had to be indexed. <br />
<br />
256 MB Ram, 2Ppro, 16GB raid 5. 100baseT connections<br />
<br />

</div>
</div>


I continually receive ODBC Error 3146 in an Access97 app linked to SQL 6.5. I recently had to reinstall SQL after a struture change. I am afraid I missed some configuration option. I get this error when running INSERT INTO state ments to local temporay tables within the Access App. 
DB - 4GB

The primary table has 1.4 million rows. 8 of 27 fileds had to be indexed. 

256 MB Ram, 2Ppro, 16GB raid 5. 100baseT connections



ODBC Problem From Access97 to SQL 6.5

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.