473,322 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Size of database

Hi there,

Size of my database was 6 MB before I uploaded data which was 24 MB excel file, after I uploaded data size of the MS Access database has gone to 88 MB,

Any thoughts

Thanks
Yogesh
Apr 20 '09 #1
3 1776
Stewart Ross
2,545 Expert Mod 2GB
Hi Yogesh. The increase you mention seems fairly modest to me.

I appreciate you may not want the DB to grow from its previously-small size, but Access will be creating temporary data storage behind the scenes when you import the data (through use of temporary tables, scratchpad areas and so on). Access databases do not automatically perform data recovery or garbage collection on such temporary areas. As a result, the file size of an Access database can grow quite quickly in normal use.

Overall, 88MB remains a very small DB size. If you are concerned about the increase - which again I would stress is actually quite modest - then run a compact and repair on the database to reduce its size.

-Stewart
Apr 20 '09 #2
Thank you so for your feedback,

There are few other excel spreadsheets I am going to upload and my concern is how much the file will grow in size, since the database is going to be uploaded on Sharepoint I am afraid it will affect the performance(speed) of the database

Thanks
Apr 20 '09 #3
Stewart Ross
2,545 Expert Mod 2GB
Hi Yogesh. I have no experience of uploading to Sharepoint, but fundamentally I don't currently see any particular issues with the size of your DB even allowing for the kind of growth which is normal with Access. Its internal performance is not directly related to the size of the MDB file holding the Access application itself.

For applications accessed via web-based pages or similar it would be more usual to deploy a true client-server back-end database (based on SQL Server or similar) even if Access was used as the front end application. The issues you raise would not really apply in those circumstances at all.

Access applications can grow to around 4 to 5 times their 'optimal' size over time, hence the provision of the 'compact' part of the 'compact and repair' option under the Tools, Database Utilities menu in pre-2007 versions of Access. I doubt that this will of itself be much of an issue for you, though, at least not in terms of performance, but time will tell.

I would also advise, if you have not already done so, splitting the database into a front end which provides any forms, reports, queries and so on, and a back-end which just contains the tables. We have a basic article on what this entails in our Insights section under the title Front-End / Back-End (FE/BE).

-Stewart
Apr 20 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

19
by: dchow | last post by:
Our database size is currently 4G and is incrementing at a rate of 45M/day. What is the max size of a SQL database? And what is the size beyond which the server performance will start to go down?
7
by: Bart Torbert | last post by:
Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the...
5
by: Anand | last post by:
Hi all Please help me to find out table size in MS-SQL how can I count or identify, this specific table is using some xyz kb of space of my hdd. thanks
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
3
by: Knick via AccessMonster.com | last post by:
I am novice to MS Access Development, I regularly back my access database every 2, 3 days ...today when I was going to back my database I saw the access file on the network drive was only 9 MB...
4
by: vijay.db | last post by:
Hi Group, It's really confusing to calculate the size of the DB2 UDB database in versions lesser than 8.2. In Version 8.2 if we run the query db2 "call get_dbsize_info(?,?,?,0)" it gives us...
2
by: Bob | last post by:
Hi all, My databases seem to become corrupted as soon as they reach 2GB. Once it does become corrupted the only fix is to create a new database and transfer everything into that. I need to...
7
by: yellr | last post by:
Hi, i've spent all resources, except this one. Hopefully anyone there out could help me with a idea for this problem. We have a db2 8.2 Enterprise Edition, on AIX 5.3 Platform, this is our...
6
by: Marcolino | last post by:
Hi all, I have a simple problem but I don't know which is the best way to solve it. I need to savo into a table into access DB the location and the size of a form. Is there a way to save...
5
by: aleu | last post by:
Hi all, Could you please advise whether there are documents describing impact of MS SQL server 2005 database size on its performance? I have essentially two things in mind when writing the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.