I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

New to Access, File Size Question.

New to Access, File Size Question. in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: Question   New Access   New Access File   Size Question  
S0nY
Baton Rouge, LA USA

I am very new to MS Access i have a question. My.mdb file is 312MB, i am looking thru the mdb file at the tables and queries and what not that are in my mdb file, i am trying to figure out which tables in my mdb file are the largest.. I have found in the file menu Database properties and it tells me the total size of the mdb file, but is there a way i can see the file size of each table and wetc that are inside of my mdb file ?

Thank for the help,

David.

 Posted 13 years ago (Thread Starter)
Comment Quote
About S0nY -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12145, 3 replies
Thread Started 9/19/2007 10:08:41 AM
View Counter=3703
Location=Baton Rouge, LA USA 
Joined=13 years ago   MB Posts=53  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
Access stores lots of deleted stuff.  It sounds like you may just need to compact your database to actually get rid of the stuff you have actually deleted.  One quick way to get a handle on the size of a table is to look at the number of records and the record size.  Of course record size is dependent on the number and types of fields but you can get a rough idea of which tables are the largest.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 13 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #12151 (Level 1.1)  Reply to 12145
Thread Started 9/19/2007 12:45:09 PM
View Counter=2
Location=Home office in Fresno, CA. 
Joined=18 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
S0nY
Baton Rouge, LA USA

Hmm, while waiting for a reply from someone, i made a copy of my mdb file and placed it on my desktop, and tried deleting tables 1 by one trying to figure out which table or file i should say was causing my mdb file to be so large, eventually i ended up deleting everything in the mdb file but the properties still says that the mdb file is 312 mbs, but yet it doesnt have any tables/queries/forms or anything in it, how is that possible ?

 If you have gotten lost and dont know what i am asking it is this, my mdb file used to be like 20 mb, now for some reason its 312mbs, i am trying to figure out why, im looking thru the files inside the mdb file to see if something is wrong or etc....

Any ideas anyone ?

 Posted 13 years ago (Thread Starter)
Comment Quote
About S0nY -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12147 (Level 1.2)  Reply to 12145
Reply Posted 9/19/2007 10:55:27 AM
Location=Baton Rouge, LA USA 
Joined=13 years ago   MB Posts=53  
Most Recent Post
S0nY
Baton Rouge, LA USA
Again Daniel, you once again helped me, thank alot ! hehe
 Posted 13 years ago (Thread Starter)
Comment Quote
About S0nY -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12154 (Level 1.3)  Reply to 12145
Reply Posted 9/19/2007 2:31:43 PM
Location=Baton Rouge, LA USA 
Joined=13 years ago   MB Posts=53  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P184A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12145 Counter
3703
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech