Access File Size and Data

Question

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

Answer 1

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