<div>
Not for a Backend database (i.e. Tables only). <br />
<br />
File growth occurs for many reasons. Adding and Deleting a lot of records can of course cause it. Storing OLE objects (image, Excel spreadhseets, etc) in the database can cause this as well.<br />
<br />
Have you compacted your FE file as well?
</div>


Not for a Backend database (i.e. Tables only).

File growth occurs for many reasons. Adding and Deleting a lot of records can of course cause it. Storing OLE objects (image, Excel spreadhseets, etc) in the database can cause this as well.

Have you compacted your FE file as well?

<div>
I am actually using a C# application that grabs a copy of the front end from a shared drive, copies it to their local machine and then runs the application so each person has their own FE that can be compacted and repaired each time they close the file
</div>


I am actually using a C# application that grabs a copy of the front end from a shared drive, copies it to their local machine and then runs the application so each person has their own FE that can be compacted and repaired each time they close the file

<div>
<div class="content wysiwyg-content">
Is there any difference in a .accde and .accdb file type being used for the back end of an access database in regards to the amount of file size growth between compact and repairs?<br />
<br />
Additionally, is there any way to minimize the growth in file size and how does it occur on a back end file only storing tables? Is there something I could be doing in the front end that is causing it to grow unduly?<br />
<br />
The only time I have exculsive access to compact and repair the database is at night which brings the file back down to the appropriate size, but by the end of the day the file is almost double to original size.
</div>
</div>


Is there any difference in a .accde and .accdb file type being used for the back end of an access database in regards to the amount of file size growth between compact and repairs?

Additionally, is there any way to minimize the growth in file size and how does it occur on a back end file only storing tables? Is there something I could be doing in the front end that is causing it to grow unduly?

The only time I have exculsive access to compact and repair the database is at night which brings the file back down to the appropriate size, but by the end of the day the file is almost double to original size.

accde vs. accdb for back end DB

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.