Database size increase

[Daveo]

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

[Allen Browne]

Re: Database size increase

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\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.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" <writetodaveo@g mail.com> wrote in message
news:1123117067 .552207.81580@g 44g2000cwa.goog legroups.com...[color=blue]
>
> 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[/color]

[Allen Browne]

Re: Database size increase

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\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.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" <writetodaveo@g mail.com> wrote in message
news:1123117067 .552207.81580@g 44g2000cwa.goog legroups.com...[color=blue]
>
> 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[/color]

[Daveo]

Re: Database size increase

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

[Daveo]

Re: Database size increase

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

[Allen Browne]

Re: Database size increase

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" <writetodaveo@g mail.com> wrote in message
news:1123199214 .873039.229800@ g44g2000cwa.goo glegroups.com.. .[color=blue]
> 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[/color]

[Allen Browne]

Re: Database size increase

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" <writetodaveo@g mail.com> wrote in message
news:1123199214 .873039.229800@ g44g2000cwa.goo glegroups.com.. .[color=blue]
> 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[/color]