Access 2007

  • Thread starter Thread starter Lucinda
  • Start date Start date
L

Lucinda

I am trying to link tables from SQL 2000 to my Access database. I select
import/link ODBC but when I followed the screen options it only allows an
import. How do you link tables?

I know it works great in Access 2003; however when I run the jobs it only
returns 10,000 rows when in SQL it returns 41,000 rows. Why is that?

Thank you.
 
I'm not sure about linked tables but in an adp there is an option to only
retrieve x rows from a table, and the default is 10,000 rows. You can
increase the limit if you're sure you want to return 41k rows. You might
consider changing the form operations to only retrieve the row the user
wants to see.
 
Back
Top