1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to tune the Access Database

Discussion in 'MS Access' started by devisrin4, Jan 23, 2007.

  1. devisrin4

    devisrin4 New Member

    Joined:
    Jan 23, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    hi

    before writing the code in MSAccess 2003, the size of the database is 38MB after wrting the code to transfer the data of one tble to another table it is showing it as 272MB.i don't know what the problem is. so plz help me on this

    Thank You
    Srinivas
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    Try exporting the database into 97 or 2000 format and you will see the size of the database decreasing considerably. I used the above techniques when in college to email the databases.
     
  3. devisrin4

    devisrin4 New Member

    Joined:
    Jan 23, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    I think if we convert the databse to 97 ot 2000, we might loose the features and securitys that are there for 2003. but i got solution by doing compact and repair databse from tools mesnu -> databse utilities.

    Thanks for sharing your thoughts
     

Share This Page