469,343 Members | 5,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,343 developers. It's quick & easy.

DB Grows, possible to auto compact DB?

ChaseCox
294 100+
Hello All,

I was wondering if anyone had ever experienced this.

When ever I use my DB, it continues to get larger. Is there away to automatically compact the database upon closing or opening? Any help would be greatly apprecited.

If you need some more information, please let me know.
Apr 3 '07
53 4399
NeoPa
32,183 Expert Mod 16PB
Good job.
Did the /nostartup have the desired affect?
Apr 11 '07 #51
ChaseCox
294 100+
Good job.
Did the /nostartup have the desired affect?
I did not use that, so I do not know. This is what I used.

Expand|Select|Wrap|Line Numbers
  1. @echo off
  2. cls
  3. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "S:\XTEAM\Reliability\Falcon_Analysis.mdb"/Compact
  4.  
Apr 12 '07 #52
NeoPa
32,183 Expert Mod 16PB
Presumably this gave you the same problem as before then?
You're obviously happy enough so I can be too :)
Apr 12 '07 #53
ChaseCox
294 100+
Presumably this gave you the same problem as before then?
You're obviously happy enough so I can be too :)
No, it does not prompt me to say ok once it is finished running.
Apr 12 '07 #54

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Charles McCaffery | last post: by
3 posts views Thread by trueblue7 | last post: by
20 posts views Thread by deepak | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.