Forum Discussion

tryingmybest's avatar
tryingmybest
Copper Contributor
May 11, 2023

Access to Linked Table file size limits

When I query a large linked table from an access database, if the table is too large, for example with 5-10 million rows or so, the access database gets too large and then runs into an issue. How can I stop the access database from getting too large while running the query on the linked table? 

access

1 Reply

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    May 12, 2023

    tryingmybest 

    There are a number of considerations here, and it's hard to offer more than generalities in this context.


    First, where are these linked tables? SQL Server? Another server-based database? A split accdb?


    Second, what do these queries actually do? Are you simply running SELECT queries on a single table? Multiple table queries? Append or Update queries?

     

    Third, are the tables properly indexed? Referential Integrity enforced on relationships?


    The more context you provide, the better our chances of being able to offer usable feedback.

     

    Thanks.

Resources