Discussion Locked

Access Limitations with ODBC Link Tables

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Do I have same limitations (on quantity of records or file size) when I link an ODBC (say MS SQL) table, that I have on a local table on Access Databases?

5 replies

by donq

No - as long as the data processing is accomplished on the server via stored procedure and only a result is returned to Access that fits within the front ends structure.

by fofa

If you are using a PassThrough query, there is a row limit in the query properties. I do not know off the top of my head if it is defaulted to anything however.

This discussion is closed to new replies.