Results 1 to 3 of 3
  1. #1
    brharrii's Avatar
    brharrii is offline Advanced Beginner
    Windows XP Access 2010 64bit
    Join Date
    Jun 2012
    Location
    Seattle, WA
    Posts
    63

    How to know when to start a new Database

    I built a product spec database.
    - Forms, Queries and reports are all managed by me.
    - stores a record of each product we create
    - allows new products to be added as time goes on
    - Prints reports to ensure compliance with specifications
    - approximately 1000 records, will probably continue to grow


    Now I need to build a database that will be used to record quality assurance checks on the same products from the product spec database.

    - forms will be used by our QA department to enter results of daily QA checks
    - primarily used for data entry and trend analysis.
    - will add a few hundred records each day
    - needs a few fields from the Product Spec database to perform weight calculations.

    I'm trying to decide if I should create a completely new database or just add more tables / forms/ reports to the one I already have. I worry a little bit about the database getting too big and un manageable, but wanted to get a some thoughts before I went one way or the other.

    Thanks



    Bruce

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    Number of records is not limiting factor, file size is. Access file size is limited to 2gb. I have a split database with FE of 43mb and BE of 130mb.

    Design edits cause file size to bloat. Run Compact & Repair periodically, especially after extensive edits.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Generally if the functionality is similar, I'd put it in the same db, if it's different I'd create a new one that linked to the data table in the first. You don't want to maintain the same data in two places.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Where to start
    By Adsso in forum Access
    Replies: 1
    Last Post: 02-15-2012, 04:25 PM
  2. How to start?
    By bergjes in forum Queries
    Replies: 8
    Last Post: 12-28-2011, 11:52 AM
  3. Start a new database
    By bsmth02 in forum Access
    Replies: 1
    Last Post: 09-29-2011, 02:55 PM
  4. Where to start?
    By FullyFamous in forum Database Design
    Replies: 7
    Last Post: 12-20-2010, 03:27 PM
  5. Start form on opening database
    By Ted C in forum Forms
    Replies: 2
    Last Post: 08-10-2010, 08:00 PM

Posting Permissions

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