Database Getting Awfully big

[Papou]

I'm builing a database, it has 15 table and forms, and 4 query and report. In total, there is maybe 1000 records in the database. Nevertheless, the size of my database is 54 Megs, I try to "Compact and repair" but it doesn't give much. When I zip it, it goes down to 2,5 megs

Any idea why and how I can solve the problem?

 

[pcdaveh]

Create a new blank database. Import all the tables, queries, macros, reports, forms and modules. You'll need to reistablish any relationships that you may have set up. See if this helps. It shouldn't take that long to accomplish this procedure.

 

[Ricky1946]

Hello Papou,
I cannot understand how a database of your size become 54 megs. What on earth have you done that is making it that size. Do you have very, very, very wide fields on your tables?
Give us a clue as to how you have developed this.
Regards
Ian "To say 'thankyou' encourages others."

 

[Papou]

My fields aren't large., I have a couple of Memo fields but not more than 10 maybe. I've built several other database and never faced this problem. I've already tried to import everything in a new database...didn't work...

 

[Ricky1946]

Papou,
Following on from pcdevah's reply I can only say that there must be something wrong with the application itself so if importing does not work how about physically 'cutting' and 'pasting' each table and form etc into a new database, perhaps this will work, but as pcpavah said you will have to re-create all of the relationships again.
A big job but it might work.
Regards
Ian
:-( "To say 'thankyou' encourages others."

 

[Francescina]

50 MB file size is really very unusual. Here just a couple of hints:

Do you use temporary tables? If so, replace them by external files (CSV is best).

Do you integrate binary data (such as JPG/GIF)? Then only store the pathnames or use another OLE server (see Access Online Encyclopedia:

http://www.unsoftwareag.com/togwa.htm

for details).

Do you close and destroy all database objects (connections and recordsets)? If not, change your code.