SQL Server -> Access 97 problems

[sbrown]

I'm in a bit of a jam.  At work we use Websesnse for controlling out web traffic, and more prominantly, recording usage log files.  Each request for a specific URL is logged, with a unique identifier, User ID, Date/Time, etc.  The porblem is this: when I query the this table, 99% of the records return A-OK.  However, once in a while, I will get the message that the text I am trying to paste is too large, and I will have to hit OK 4 times, and suddenly ALL the records that would have been returned show #Name? in their fields, rather than just the ones(s) with the errors.  When I show the tables in SQL Server Ent. Manager, these records show up fine.  Are there any known issues with using pass-though queries and Windows NT ODBC drivers?  Any help would be greatly appreciated.

 

[DougP]

Take a close look at all of your columns (fields) in SQL.<br>Note the length and type of each.<br>How are you adding the records to SQL? From Access or from some other way?<br>The message as you probably know is becasue you are trying to add a record to SQL that is longer than the column (field) length.<br><br>SQL calls fields, columns and Rows in SQL are Records in Access. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[sbrown]

The records are being added by a service running on the same Compaq Proliant 3000.&nbsp;&nbsp;There are no problems there, heck, the tables were set up by that same service.