Database size in relation to content

Originally Posted by Nathan H

I have a strange question

Is there a method for determining the proper or standard size of a database (MB, GB) in regards to records and fields in the database?

I have a database with 30,000 records, with 10 fields per record. It just seems a little big in size even after compacting. No Code, No queries, just a table to run a catalog on a website.

Thanks.

Nathan

Originally Posted by JustJim

Hi Nathan,

Yes, it all depends on the datatypes of the fields in the table. Each datatype sets aside an amount of memory depending what it will be asked to store. Obviously a Boolean field (Yes/No) only uses a little bit (computer pun there!) of memory while a Double field uses more. You can multiply it all out and get the size that the table should take.

Don't forget that there is much more in an Access Application than just your table though. Try clicking on <Tools> <Options> <View> and put a tick in "System Objects" and looking in the Tables view of the Database Window. These system objects and other stuff will obviously add to the total size of your application over and above your one table.

Jim

Originally Posted by Nathan H

Thanks Jim, the System Objects revealed a lot!

Originally Posted by JustJim

Yes it does, now take the tick out of the box and don't mess with them ever again. Down that road lies madness, madnessss, madddnesss, I tell you.

'AveAGoodWeekend

Jim