Access File Size and Data

Flinn, Randal J 281 Reputation points
2022-02-14T16:17:57.14+00:00

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.)?

Thanks

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.
825 questions
0 comments
Accepted answer
  1. Karl Donaubauer 1,646 Reputation points MVP
    2022-02-14T16:52:36.277+00:00

    Hi,

    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.

    Servus
    Karl
    Access News
    Access DevCon

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest