Update Query Won't Update Table Past Row 10000

[DomDom3]

Hi there,

I'm using an adp on an SQL Server 2000 backend, I have a simple update query (see below) which I'm using to update every row in a table field with the date.

UPDATE dbo.testtable
SET date_added = { fn NOW() }

But...The Update procedure will only update the first 10,000 lines of the table, the rest remain blank. If I run the procedure using Server Management Studio it works perfectly. I assume then that the Access front end is the problem. I've run the query in a purely access database and it works for all rows - it seems its the adp.

Can anyone shine any light on this please?

 

[DomDom3]

Having already changed in the table the max number of rows to return and in tools and options - Edit/Find, I found yet another place tools, options - Advanced where I had to change the default number of records from 10000.