Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpiscit1
Posting Yak Master
130 Posts |
 Posted - 2004-08-19 : 09:37:48
|
| I am using MS Access(2000) as a front end to a MS SQL2000 DB. I set up a table link to one of the tables in the SQL server. The table I am linking to has 242 Fields in it. The table shows 21888 rows of data. In Access, when I set the record source in a Form to this linked table and go to run (Form) view, I get a "Record to Large" error. In the SQL table - there is one varchar field that is 17 in length. There are about 5 char fields and the rest are numeric or date. My questions are:What is causing this error? What would be a good work around or other possible solutions?Thanks. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
|
|
|
|
|
Records to Large Error