We help IT Professionals succeed at work.
Get Started

accde vs. accdb for back end DB

wipnav
wipnav asked
on
1,920 Views
Last Modified: 2012-05-10
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.
Comment
Watch Question
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE