Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database size - what is too big? (97)

    My question is whether I should be getting worried about the size of my database. Right now there are 75,821 records, file size is 46,762KB. What is the maximum database size, and should I be doing anything, like compacting it?

    Any suggestions would be appreciated.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database size - what is too big? (97)

    Repairing and Compacting a database on a regular basis is always a good idea.

    Access should be able to handle a db up to 1 gig (1,000,000kb).


    Hope this helps.
    Richard

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Database size - what is too big? (97)

    No problem with a database that size. You can compact it using the built in compacting utility (from menubar select Tools| Database Utilities | Compact Database) or by using JetComp (available free from Microsoft website). For Access97, Microsoft warns against using the internal repair utility UNLESS the database tells you it is having a problem and offers to repair itself. JetComp does a repair as well as a compact.

    You didn't say whether this was a frontend/backend schema, or just one big database. Splitting into frontend/backend usually results in few problems with database corruption of the backend.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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