Access File Size and Data

Flinn, Randal J 281 Reputation points

I currently have a database that is 1,490,796 KB (and will continue to grow). I recently had a time where compact and repair provided an error due to the file size.

Is there a good/better way to maintain this data (i.e., storage of data in a separate location, etc.)?


Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
757 questions
0 comments No comments
{count} votes

Accepted answer
  1. Karl Donaubauer 1,481 Reputation points MVP


    It depends on the nature of data, application, data access and environment. So, a few factors.

    In any case the database should be split into frontend and backend. I hope you are already talking about the backend file only.

    It is not a problem to link two or more Access backend files into a frontend. Either divided contentwise or organizationally, e.g. with current and archive data, which is also good for performance.

    What of it makes sense or if you should better go to a SQL Server or the like, can only be said on the basis of more details.

    Access News
    Access DevCon

    0 comments No comments

0 additional answers

Sort by: Most helpful