Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Access to Linked Table file size limits

Copper Contributor

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? 

1 Reply

@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.