Access 2007



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.

Paul Shapiro

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question