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 2 or 3 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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problems with SQL Server -> MS Access interface
- Thread starter sbrown
- Start date
Similar threads
- Question
- Locked
- Question
