EasyCFM.COM ColdFusion Forums / MS Access Related Issues / Access DB size....

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Access DB size....

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

SouthLand
04-06-2005 @ 10:33 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 105
Joined: Jun 2004

my database size gets bigger and bigger no matter how much data is taken out. I have deleted 4 tables that had atleast 80,000 records filled with 25 columns full of data and the size stayed the same.

I tried copying over the structure of my one table only and the size stayed the same when i imported it.

anybody know why my database size stays the same even when i delete information from it?

also if i am going to use access for the web, how many users at one time can hit the database and get information?

can access be used for a site that will have 100-200 users on at any time doing queries?

thanks a lot guys.

andrew@nexgenimaging.com

JJfutbol
04-06-2005 @ 11:51 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 1250
Joined: Nov 2004

I agree as I suffer from the same problem when I edit my databases for my website. I have about 4 now and if I have taken away tables the file size doesn't change. Maybe its just the way Access is built.

Need browser testing?? I have 8 browsers on my PC including: IE6, NS4.8, NS6, NS7.2, NS 8 (Beta), Opera, Mozilla, and Mozilla Firefox.

SouthLand
04-06-2005 @ 11:59 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 105
Joined: Jun 2004

if thats the way access is built...thats ridiculous.
atleast someone else has the same prob as me.

Im not really needing browser testing, because all of the users are using ie5+. Im more needing info on how many users Access can support hitting the database at any given moment.



megan
04-06-2005 @ 1:13 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

snip>>>


Compacting an Access File

As you work on your database, particularly when developing it, the Microsoft Access file will grow and grow. Microsoft Access files never automatically get smaller, even when you have deleted data from them.

As a database continues to grow, there may be errors that spring up along the way. As the database administrator, it will be your responsibility to manage these. When errors do occur in your database, they will take up valuable space and this may lead to performance issues.

The database will grow and expand over time, and if you delete data or objects in an Access database, or if you delete objects in an Access project, the file can become fragmented and use disk space inefficiently.

Compacting the Microsoft Access file makes a copy of the file and rearranges how the file is stored on your disk.

Every now and then, you should ensure that you run the Compact and Repair utility available in Microsoft Access as this will help keep errors and file size down to a minimum, and will ensure that database performance is kept at a maximum.

Compacting a Microsoft Access database can reduce the size of the .mdb file by as much as a factor of two or three.

To Compact and Repair a Microsoft Access Database (Access 2000, 2002 & 2003):

Open the database you would like to perform the Compact and Repair on
Choose Tools >> Database Utilities >> Compact and Repair Database

also see
http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=9






We have art so that we shall not die of reality ~ Nietzsche


Website Designed and Developed by Pablo Varando.