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