MDB Size

C

Chaster

Could someone explain to me how the size of the mdb file is determined by
access?

What I believe to be my front end is showing a size of 17 MB after
compacting

Does the linked tables have anything to do with the size?

I have serveral very large tables linked to this project but this mdb only
has about 20 queries, 20 forms, 5 very small tables, 6 reports, and a couple
of modules within the mdb itself.

TIA
 
P

Peter Russell

17Mb sounds ridiculous on the face of it.

Create an empty database and import everything from the current db.
Compact, compile and see what you get then.

Regards

Peter Russell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Huge size increase in mdb file 3
mdb data file size rapidly grows 3
Database size 2
MDB with only linked tables growing tremendously 15
security on back end mdb 4
Relationship between MDB file size and amount of VBA used 5
Size of MDB code 1
MDB corrupt after rebuild, decompile & LoadFromText() 5

Top