Results 1 to 3 of 3

Thread: help! access db grows to quickly...

  1. Jul 18th, 2000, 08:06 AM #1
    arnas
    arnas is offline

    Thread Starter
    Member
    Join Date
    May 2000
    Posts
    32

    Unhappy

    hi. I have just made my first Db, but I suspect it grows too quickly. there are only 4 tables in the Db. the main table have 25 columns. a 'Byte' and 'Text' (the longest is 45 symbols) types dominate there. so, for this moment I have only 300 records, but my Db is already 10 Mb... I am sure with normalization everything is ok. so what's the problem??? Is it normal?
    thanx!!!
    Arnas
    Reply With Quote Reply With Quote
  2. Jul 18th, 2000, 09:16 AM #2
    lenin
    lenin is offline
    Addicted Member
    Join Date
    Feb 1999
    Location
    Belfast
    Posts
    254
    Hi amas,
    I have seen this before. I am not sure as to the cause but I had an access database with 60 records which was 40MB. I recreated the tables in a new database and exported / imported the data. This was the only resolution I found.

    Lenin
    Reply With Quote Reply With Quote
  3. Jul 18th, 2000, 12:42 PM #3
    DrewDog_21
    DrewDog_21 is offline
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Columbia, SC USA
    Posts
    374

    Cool

    The thing about Access databases is that when you add a record, the file grows in size. But when you delete a record, the file does not shrink in size. I have heard various explanations as to why this is the case. The article at the following link shows how to compress the database with code:

    http://www.vb-world.net/databases/tip482.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width