Results 1 to 5 of 5
  1. #1
    TTDD is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4

    Database size - pls help urgent!!

    I have to start bulding an access database with time series data of ewquity securities starting from 1980. I have to store about 60 fields for 5000-6000 securities from 1980 till date on a quarterly basis( 4 dates/year) . I can break the fields into 5-6 logical tables and connect them using the security ID.



    This data amounts to be about 11 million records split across ifferent tables and will grow each quarter with 200000 records.

    I am not sure if I will breach the size limits with this ? should I build this in access or sql?? One solution i was thinkin was to split the db into 2.
    Please help.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If SQL Server is an option then why not just jump right in? You can still use Access as the FrontEnd.

  3. #3
    TTDD is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    4
    I am comfortable with access databases. Most of the models/tools I have built involve storage of historical data -which I do in access - and extract the data into excel to do statistical analysis.
    Does Sql work well with Excel as we need to bring this data to excel to do some statistical analysis?

    Also do you think it is very impractical to think of doing this in access split databases?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I don't have the answer to some of your questions but the limit on Access is 2GB per file. You can have any number of files being manipulated by one FrontEnd in Access. I am a BIG advocate of splitting the tables out into a BackEnd in Access.

  5. #5
    Max D's Avatar
    Max D is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    63
    Quote Originally Posted by TTDD View Post
    This data amounts to be about 11 million records split across ifferent tables and will grow each quarter with 200000 records.
    I have counted a bit and I think you are talking about 11M fields, not records. The whole table row is called record.

    Its better to use SQL Server, despite your data can fit regular Access database. There is SQL Express edition - it have 4 Gb database size limit.

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

Similar Threads

  1. Linked OLE Objects bloating size of database
    By Nosaj08 in forum Database Design
    Replies: 18
    Last Post: 07-09-2009, 05:54 PM
  2. Concatenation Urgent Help
    By Shoaib in forum Queries
    Replies: 0
    Last Post: 04-23-2009, 11:02 PM
  3. Access Database size Grows too fast
    By no-e in forum Access
    Replies: 0
    Last Post: 12-16-2008, 02:29 PM
  4. Replies: 2
    Last Post: 07-24-2006, 09:19 PM
  5. I need help! Urgent! :(
    By Suzan in forum Database Design
    Replies: 0
    Last Post: 04-08-2006, 11:58 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums