locked
access database store RRS feed

  • Question

  • In access database how many data I can store . I want to know in access have any limitation for data store
    Wednesday, September 2, 2015 3:23 PM

Answers

  • The 2 gig limit is per file. You can of course have multiple files if you particularly want to use access.

    You might want to consider sql server express instead though.

    You can now use this without services using localdb:

    "

    Embed lightweight database into basic desktop applications

    SQL Server Express LocalDB is a lightweight deployment option for SQL Server Express with fewer prerequisites. This makes it ideal for developers who need an embedded SQL Server database for desktop applications or tools. LocalDB runs in-process with applications and not as a service.

    "

    http://www.microsoft.com/en-gb/server-cloud/products/sql-server-editions/sql-server-express.aspx


    • Proposed as answer by DotNet Wang Friday, September 4, 2015 9:22 AM
    • Marked as answer by Youjun Tang Thursday, September 10, 2015 2:25 AM
    Thursday, September 3, 2015 8:43 AM

All replies

  • Hi benjir01,

    Different versions has different specifications. Total size for Access 2010 and  Access 2007 is 2 gigabytes. You could reference below specifications.

    Access 2007 specifications
    Access 2010 specifications

    Best Regards,
    Li Wang

    Thursday, September 3, 2015 2:33 AM
  • I Use Access 2007   
    Thursday, September 3, 2015 5:06 AM
  • Hi benjir01,

    For Access 2007, please check below link.

    https://support.office.com/en-au/article/Access-2007-specifications-2eedf198-6b27-4dc5-ae07-3e1fba6d6c96

    Best Regards,
    Li Wang

    Thursday, September 3, 2015 5:29 AM
  • The 2 gig limit is per file. You can of course have multiple files if you particularly want to use access.

    You might want to consider sql server express instead though.

    You can now use this without services using localdb:

    "

    Embed lightweight database into basic desktop applications

    SQL Server Express LocalDB is a lightweight deployment option for SQL Server Express with fewer prerequisites. This makes it ideal for developers who need an embedded SQL Server database for desktop applications or tools. LocalDB runs in-process with applications and not as a service.

    "

    http://www.microsoft.com/en-gb/server-cloud/products/sql-server-editions/sql-server-express.aspx


    • Proposed as answer by DotNet Wang Friday, September 4, 2015 9:22 AM
    • Marked as answer by Youjun Tang Thursday, September 10, 2015 2:25 AM
    Thursday, September 3, 2015 8:43 AM