I have a SQL (2000) table with 70,000 + records and about 25 columns. I am
having difficulty editing or adding data from MS Access (2003). I can edit
the table directly in SQL without difficulty. I've tried refre****ng the
link,
relinking, and even stopping and restarting SQL server. None of this has
helped. I am suspecting I am hitting a limit in terms of Access' file
handling. Is this likely?
Queries based on just a couple of records won't update if the table in
question is part of the SQL statement.
--
sam
