Okay I deleted all queries, forms, reports and modules from a single database - compacted and repaired - still I have the size at 12,000 KB. That is just too large!
I have 37 total tables and I plan to go through all the TEXT fields and be sure that not all are at 255 size - most of which seem to be at 25 length instead. What other measures can I take to reduce the size of the databases besides field size?
If database size can be reduced by limiting the number of indexes- what is some VBA code in which I may list all my indexes?
ALSO - as I was typing this question - I went ahead and created a new database and imported the tables only. Now I get 2,880 KB this time for the newly created database that has the tables. How come when I create a new database and import the tables - the size is less than when I delete all my queries, forms, reports and modules with keeping just the tables?
Also what that tells me is when I run an update on the database don't merely import other forms, reports, and queries - just create a new database and then import the tables - then theh rest and the size will be smaller? To me that doesn't make sense - is there a proper explanation for this?
Thank you for your help thus far!