Results 1 to 2 of 2
  1. 03-15-2010, 09:33 AM #1
    slimjen
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    records

    Can anyone tell me how many records can an access 2007 table hold? I have a table and for the month of february alone; there are 679,000 records. I am wonder if I should create a table for each months data rather than one table to hold all the records for the year.
    Thanks
    Reply With Quote Reply With Quote
  2. 03-16-2010, 10:10 AM #2
    ConneXionLost's Avatar
    ConneXionLost
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi slimjen,

    There's no specified limit to the number of records in a table, but an Access database has a memory size limit of 2 gigabytes, minus the space needed for the system objects. This limit will eventually impact the table size.

    Cheers,
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums