By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,377 Members | 3,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,377 IT Pros & Developers. It's quick & easy.

Database size increase

P: n/a
Hi there,

Is there any reason why my db would almost double in size after I
copied everything to a new db after my old one became corrupted? Is it
anything to worry about?

Thanks - David

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
In the new database:

1. 1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact: Tools | Database Utilties | Compact.

3. Then decomile. Enter something like this at the command prompt while
Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

In some versions, you may still see a small increase in size, but not a
doubling.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daveo" <wr**********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Is there any reason why my db would almost double in size after I
copied everything to a new db after my old one became corrupted? Is it
anything to worry about?

Thanks - David

Nov 13 '05 #2

P: n/a
In the new database:

1. 1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact: Tools | Database Utilties | Compact.

3. Then decomile. Enter something like this at the command prompt while
Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

In some versions, you may still see a small increase in size, but not a
doubling.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daveo" <wr**********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Is there any reason why my db would almost double in size after I
copied everything to a new db after my old one became corrupted? Is it
anything to worry about?

Thanks - David

Nov 13 '05 #3

P: n/a
Hi Allen,

Will doing this cause me problems if I rename a table/field or
anything, or should I only do it when my database is finished?

Thanks - David

Nov 13 '05 #4

P: n/a
Hi Allen,

Will doing this cause me problems if I rename a table/field or
anything, or should I only do it when my database is finished?

Thanks - David

Nov 13 '05 #5

P: n/a
Do it now.

Only in rare conditions (when the database is already compromised) will
those steps cause things to get worse.

In any case, make a copy of the mdb file before applying the steps, so you
can always go back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daveo" <wr**********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hi Allen,

Will doing this cause me problems if I rename a table/field or
anything, or should I only do it when my database is finished?

Thanks - David

Nov 13 '05 #6

P: n/a
Do it now.

Only in rare conditions (when the database is already compromised) will
those steps cause things to get worse.

In any case, make a copy of the mdb file before applying the steps, so you
can always go back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daveo" <wr**********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hi Allen,

Will doing this cause me problems if I rename a table/field or
anything, or should I only do it when my database is finished?

Thanks - David

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.