The number of records is quite large (about 100k records). Indexes are in place and the query executes within about 5 seconds inside Access, so the time is getting used filling the BO.

This is a read-only view. The fill routine is just "select * from blah" (blah is a view). Can anyone suggest a way to speed the fill routine up?

Thanks!