When an Access .MDB is linked to a table from a remote database (e.g. SQL MS Server) that is known to be valid (not dropped or locked) and the rows in the table are full of "#Error" strings then try to SELECT * from the table via an Access Pass-Through Query. If you get an error like "Record too large" then the table you are linking to has columns that exceed the 2K limit reserved for the "data page."

To avoid this problem, delete the linked table and use a Pass-Through Query that shows the only fields you need. For more information, as of this writing, Microsoft touches upon this issue in their Knowledge Base article "DOC: Additional Jet Database Record Size Information" (Q198660):

http://support.microsoft.com
    /support/kb/articles/Q198/6/60.ASP