Decompile

[Sal]

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?

Thank You
Sal

[Allen Browne]

Yes, Access 2002 is likely to do that.

To get Access to recreate it for you:
1. Create a new database.

2. Turn off the Name AutoCorrect check boxes under:
Tools | Options | General.

3. Import (File | Get External | Import) the tables, or link them (File |
Get External | Link) if the database is split.

4. Import the other objects (queries, forms, reports, macros, modules.)

5. Set minimal References under Tools | References (from the code window).
If you are not sure which ones you need, see:
http://members.iinet.net.au/~allenbrowne/ser-38.html

6. Compile (Debug menu, from the code window).
--
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.

"Sal" <sl*****@bellatlantic.net> wrote in message
news:f88rd.1542$8v3.823@trndny08...

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?

Thank You
Sal

[Tom van Stiphout]

On Wed, 01 Dec 2004 00:21:31 GMT, "Sal" <sl*****@bellatlantic.net>
wrote:

Restore a backup.
Perhaps importing all objects into a new MDB would help.
As well as not worrying about the difference.

-Tom.

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?

Thank You
Sal

[Trevor Best]

Sal wrote:

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?

After decompiling, compact it.

--
This sig left intentionally blank

[Tony Toews]

"Sal" <sl*****@bellatlantic.net> wrote:

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?

124 Mb of queries, forms, reports and modules? That's mighty large.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Trevor Best]

Tony Toews wrote:

"Sal" <sl*****@bellatlantic.net> wrote:

After I decompile my 124MB (Access 2002) *.mdb file the size increased to
135MB(compacted).
Thas anyone know why and how can I get it back to original?

124 Mb of queries, forms, reports and modules? That's mighty large.

He comments his code a lot :-)

--
This sig left intentionally blank