Results 1 to 2 of 2

Db too big and slow

  1. #1
    PoorCadaver is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    68

    Db too big and slow

    Hi!



    Recently I experimented with imported pictures in a form but I didn't like it so I deleted them. Now I see that the dabase file is over 20 MB and it should be about 5 MB. Could that have to du with the pictures (that are removed...)?

    I tried to compact and repair database and now it is 11 MB. Still a little too much and it takes about 15 seconds to save.

    How do I fix this?

    Thanks!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,898
    Try *importing* your db into a fresh new db and see if the problem follows.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Search too SLOW :(
    By DMetcalfe92 in forum Access
    Replies: 1
    Last Post: 10-10-2012, 10:04 AM
  2. What to do when a split DB is slow?
    By Datech in forum Access
    Replies: 5
    Last Post: 06-07-2012, 07:03 PM
  3. Slow Over Network
    By dnelson33 in forum Access
    Replies: 4
    Last Post: 02-07-2012, 10:34 AM
  4. Printing is slow
    By mikew in forum Access
    Replies: 2
    Last Post: 11-04-2011, 11:52 AM
  5. Slow Database
    By cadsvc in forum Database Design
    Replies: 3
    Last Post: 05-31-2011, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums