Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Table size, query size

    Hi,

    I want to know that.

    How many records can store in one table?
    How many records can run in one query?

    Please let me know, thanks a lot. Thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Display the MS Office Agent (little yellow box with a Question Mark in it) and enter the following:

    Access Specifications

    Select: Access Specifications when the list is displayed to you. All you need to know is there.

    If you don't want to go through all that then.... to put it bluntly:

    If your DB is properly organized a table can be 2 gigabyte minus the space needed for the system objects.
    And for Queries...your Recordset will provide 1 gigabyte.

    If you're reaching anywhere near this point, then boy...I'ld say you should start thinning out a little.
    .
    Last edited by CyberLynx; 10-13-05 at 03:10.
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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