What is max number of Linked tables in ACCESS 2003 ?

G

Guest

I am developing an application that uses linked tables from SQL Server db to
ACCESS, after the number of linked tables exceeded 50 I started facing some
application run time errors while refreshing the Linked Tables Connection to
SQL Server ?
Can any one help ?
 
V

Van T. Dinh

50 shouldn't be a problem. I am not using A2003 as yet but in A2002, I have
more than 200 linked Tables from SQL Server Back-End.
 

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

Similar Threads

Create Linked tables in access db without ODBC 18
Update Linked Tables 5
What database am I using? 4
Retrieving the SQL Server Name of a ODBC Linked Table in Access 20 2
ADO Connection 2
Modify Linked SQL table in Acess via VBA code 7
Failure of Linked table in Access... 5
DAO;OpenRecordset;dbInconsistent option affects number of records 0

Top