Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-13-2019, 06:23 AM   #1
JeffCooper
Newly Registered User
 
Join Date: Nov 2019
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
JeffCooper is on a distinguished road
Post Every Growing Database Doesn't Compact or Repair

I have been having a problems with an Access 2016 database app I have created. I have created numerous data bases over the years.

I created a time entry application first where about 200 users can enter in their weekly timesheets and generate reports. I made this into an ACCDE, which compiles down to about 2 meg for the app. A user can refresh their historical timesheets from the backend database to their local application and enter in hours without logging on to the system. They can just save their timesheet to the backend database at the end of the week when they are connected to the network. The Access ACCDE does not grow in application size and operates without any problems or locking issues.

I just created another Access application and it compile down to around 5 meg. Every time I log on to the Access application, it grows in size. Even if you repair and compact the database it never goes back to 5 meg or the file size that it was before the repair and compact. It keeps growing and growing to over 100 meg. The only way to get it back to the original size is to create a blank database and reimport all the tables, forms, queries, reports, and modules. I have looked at everything and the new Access application follows the same rules as the first Access application. Any ideas on why the second database behaves differently?

JeffCooper is offline   Reply With Quote
Old 11-13-2019, 08:45 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,593
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Every Growing Database Doesn't Compact or Repair

Duplicate post.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Every Growing Database and Compact doesn't work JeffCooper General 13 11-16-2019 06:49 PM
Compact and Repair Database jereece Macros 8 11-26-2014 12:02 PM
can not compact and repair database arpitraval General 1 12-19-2008 11:53 AM
Compact and repair database naym General 2 03-17-2008 07:59 AM
Compact and repair database SerenityNet Macros 2 05-08-2003 11:13 AM




All times are GMT -8. The time now is 10:30 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World