Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-12-2019, 11:06 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 and Compact doesn't work

I have been having a problems with an Access 2016 database app I have created.

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 time sheets from the back end database to their local application and enter in hours without logging on to the system. They can just save their time sheet to the back end 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-12-2019, 11:29 AM   #2
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,623
Thanks: 58
Thanked 1,455 Times in 1,436 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Every Growing Database and Compact doesn't work

Hi. Just curious, are you, by any chance, using temporary tables?
__________________
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
Old 11-13-2019, 09:23 AM   #3
JeffCooper
Newly Registered User
 
Join Date: Nov 2019
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
JeffCooper is on a distinguished road
Re: Every Growing Database and Compact doesn't work

No temporary tables just a few local tables like the first app.

JeffCooper is offline   Reply With Quote
Old 11-13-2019, 09:25 AM   #4
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,623
Thanks: 58
Thanked 1,455 Times in 1,436 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Every Growing Database and Compact doesn't work

Quote:
Originally Posted by JeffCooper View Post
No temporary tables just a few local tables like the first app.
No "make-table" queries at all? Do you delete and append multiple data a lot?
__________________
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
Old 11-13-2019, 01:51 PM   #5
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,748
Thanks: 93
Thanked 1,724 Times in 1,595 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Every Growing Database and Compact doesn't work

Something is being appended WITHOUT being deleted. By any chance, do you have anything that does OLE operations? Importing an object? Using an attachment field (and then actually attaching something)?
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is online now   Reply With Quote
Old 11-14-2019, 07:31 AM   #6
JeffCooper
Newly Registered User
 
Join Date: Nov 2019
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
JeffCooper is on a distinguished road
Re: Every Growing Database and Compact doesn't work

Both Apps have delete and insert queries. There are no ole objects or attachments in the tables. There are a couple of calculated fields. I checked and the table doesn't increase or decrease in number of records. I can just close and open the database without doing anything and it keeps growing.
JeffCooper is offline   Reply With Quote
Old 11-14-2019, 08:56 AM   #7
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,623
Thanks: 58
Thanked 1,455 Times in 1,436 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Every Growing Database and Compact doesn't work

Quote:
Originally Posted by JeffCooper View Post
Both Apps have delete and insert queries. There are no ole objects or attachments in the tables. There are a couple of calculated fields. I checked and the table doesn't increase or decrease in number of records. I can just close and open the database without doing anything and it keeps growing.
Hi. Opening and closing without you doing anything doesn't mean there are no code in the database that does something like deleting and inserting a lot of records. Is there? If you disable all the code from the database and then open and close it, does it still increase in size?

__________________
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
Old 11-14-2019, 09:20 AM   #8
apr pillai
Newly Registered User
 
apr pillai's Avatar
 
Join Date: Jan 2005
Location: India
Posts: 686
Thanks: 3
Thanked 109 Times in 96 Posts
apr pillai will become famous soon enough
Send a message via AIM to apr pillai Send a message via Yahoo to apr pillai Send a message via Skype™ to apr pillai
Re: Every Growing Database and Compact doesn't work

Check with your Network Administrator about your Disk-Quota Allocation. You need double the size of your Database Free Space on Server to Compact your large database.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
(Learn MS-Access Tips and Tricks)

All responses are based on Access2003/2007
apr pillai is offline   Reply With Quote
Old 11-14-2019, 09:49 AM   #9
JeffCooper
Newly Registered User
 
Join Date: Nov 2019
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
JeffCooper is on a distinguished road
Re: Every Growing Database and Compact doesn't work

There is plenty of disk space for a compact and repair. The queries do run but add less than 10,000 rows in entirety. I tried removing the calculated fields from the front end and back end. The Access database should go back to its original size and not keep growing and growing. Ugh
JeffCooper is offline   Reply With Quote
Old 11-14-2019, 09:59 AM   #10
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,623
Thanks: 58
Thanked 1,455 Times in 1,436 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Every Growing Database and Compact doesn't work

Quote:
Originally Posted by JeffCooper View Post
There is plenty of disk space for a compact and repair. The queries do run but add less than 10,000 rows in entirety. I tried removing the calculated fields from the front end and back end. The Access database should go back to its original size and not keep growing and growing. Ugh
Hi Jeff. Since we cannot see into your environment, I'm afraid it's very hard to offer any potential solution for your issue. If you have disabled all code and macros and still seeing the file size increase, then it could be something else outside of your database that's affecting it.
__________________
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
Old 11-14-2019, 10:13 AM   #11
JeffCooper
Newly Registered User
 
Join Date: Nov 2019
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
JeffCooper is on a distinguished road
Re: Every Growing Database and Compact doesn't work

I know my current company doesn't want to give out details. If I find something I will share the solution. Thanks
JeffCooper is offline   Reply With Quote
Old 11-14-2019, 10:14 AM   #12
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,623
Thanks: 58
Thanked 1,455 Times in 1,436 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Every Growing Database and Compact doesn't work

Quote:
Originally Posted by JeffCooper View Post
I know my current company doesn't want to give out details. If I find something I will share the solution. Thanks
Good luck!
__________________
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
Old 11-14-2019, 12:03 PM   #13
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,748
Thanks: 93
Thanked 1,724 Times in 1,595 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Every Growing Database and Compact doesn't work

Let's be clear. Databases don't grow unless (a) they are corrupt in a bizarre way or (b) despite you not knowing about it, some code IS running somewhere. Do you have an "opening form" defined? Because there is where you look.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is online now   Reply With Quote
Old 11-16-2019, 06:49 PM   #14
apr pillai
Newly Registered User
 
apr pillai's Avatar
 
Join Date: Jan 2005
Location: India
Posts: 686
Thanks: 3
Thanked 109 Times in 96 Posts
apr pillai will become famous soon enough
Send a message via AIM to apr pillai Send a message via Yahoo to apr pillai Send a message via Skype™ to apr pillai
Re: Every Growing Database and Compact doesn't work

Take a look at this link: https://www.msaccesstips.com/2008/06...h-vba.html?m=1



Sent from my iPhone using Tapatalk

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
(Learn MS-Access Tips and Tricks)

All responses are based on Access2003/2007
apr pillai 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
Question Database doesn't work now in 2013 dbadeb General 3 03-29-2016 06:44 PM
Database backup doesn't work sven2 SQL Server 4 02-06-2010 03:54 AM
Database doesn't work. victoria61485 General 3 04-23-2009 05:12 PM
My database doesn't work like before? Sucro General 1 08-22-2007 02:04 AM
currentDb in .adp database doesn't work human_anomaly Tables 1 11-25-2004 01:11 PM




All times are GMT -8. The time now is 02:12 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