Question about Microsoft Computers & Internet

1 Answer

Storage of MS-Access 2007

Hi
i want to know which is the most storage capacity in MS-Access
Please provide some sample sites.

Posted by on

  • Nikola Malesevic
    Nikola Malesevic May 11, 2010

    Can you rephrase your question, please?

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 139 Answers

(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 storage of MS-Access 2007 - default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Posted on Jan 24, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Product key


I'm sorry but this is not a warez site...We do not give out activation keys or access codes...

Jun 28, 2012 | Microsoft Office 2007 Basic for PC

1 Answer

I have a microsoft access 2007 file but i cannot open it in my cpu because my software is only microsoft access 2003


It appears that you have not been updating your Microsoft office regularly. Anyway do it now. Go to MS Office web site and upgrade/update your MS Access 2003 to MS Access 2007.

Apr 07, 2011 | Computers & Internet

1 Answer

I cant download my ms office 2007


You can download it from the below site provided

http://www.brothersoft.com/downloads/microsoft-office-2007.html

Please rate me if this solution works for you

Thanks......Have a great time

Jun 16, 2010 | Microsoft MS OFFICE 2007 SBE MLK (NA) SW....

2 Answers

Ms office product key...plsssssss for office st...


Hi,


You can find the key on the cover of the Office disk otherwise you may get in touch with the Microsoft if you have purchased the license version, the number of Microsoft is - (800) (642-7676).
Fixya does not provide Microsoft product keys. You should be purchasing a genuine license for your own use. By using an acquired free key from the internet would get you into software piracy which is illegal. Save yourself from trouble and buy a genuine license.You will also be entitled to Microsoft office downloads without further trouble.


Thank you !!

May 19, 2010 | Microsoft Office Professional 2007 Full...

3 Answers

Ms office 2007


MS Office Professional 2007 contains:

  • Microsoft Office Word 2007
  • Microsoft Office Excel 2007
  • Microsoft Office PowerPoint 2007
  • Microsoft Office Outlook 2007 with business contact manager
  • Microsoft Office Publisher 2007
  • Microsoft Office Access 2007
  • Apr 01, 2010 | Microsoft Office Publisher 2007 for PC

    1 Answer

    Ms office standard 2007 licensing cd microsoft


    Hi,
    Microsoft Access is not included in MSoffice 2007 Standard version, for it you have to upgrade to MS Office 2007 professional.

    Thanks

    Jul 02, 2009 | Microsoft Office Professional 2007 Full...

    4 Answers

    Ms office product key


    Hi, 
    Ms Office Enterprise 2007 Product Key.
    V9MTG-3GX8P-D3Y4R-68BQ8-4Q8VD

    Hope this Helps, Please Rate My Response! Thanks! PREM

    Feb 20, 2009 | Microsoft Office Professional 2007 Full...

    Not finding what you are looking for?

    Open Questions:

    Computers & Internet Logo

    Related Topics:

    597 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2644 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18381 Answers

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...