Access Database split but still is 2 gig

%3CLINGO-SUB%20id%3D%22lingo-sub-3194180%22%20slang%3D%22en-US%22%3EAccess%20Database%20split%20but%20still%20is%202%20gig%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3194180%22%20slang%3D%22en-US%22%3E%3CP%3Ewhat%20do%20i%20do%20to%20be%20able%20to%20use%20the%20database%20when%20the%20limit%20is%202%20gig%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3194180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eaccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

what do i do to be able to use the database when the limit is 2 gig?

2 Replies
migrate your data to mssql or mysql database

@JoeRowell 

In addition to arnel's advice, you could try a Compact and Repair on BOTH the new Front End accdb and Back End accdb to see how much bloat you can remove.

 

That said, the free SQL Server Express version has a 10GB size limit, so it's a good option. 
However, migrating from an Access BE to a server database BE can introduce a number of problems that will require design improvements in an Access FE.

 

Other considerations include much better security options with a Server-based BE.