Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2006
    Posts
    57

    Unanswered: How big can an access file be?

    hello I a creating a web application that will use both access and SQL. But im kinda iffy on using an access DB because I heard somewhere that there is a limit to the file size. Is this true?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Luke101
    Is this true?
    Yup 2GB. However free versions of SQL Server are limited in max size too....
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    ِAcce$$ limits

    1 gigabyte. However, because your database can include linked tables in other files, its total
    size is limited only by available storage capacity.

    Number of objects in a database: 32,768
    Modules (including forms and reports with the HasModule property set to True): 1024
    Number of characters in an object name:64
    Number of characters in a password:14
    Number of characters in a user name or group name:20
    Number of concurrent users:255

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Nice extra info hammbakka but I'm afraid it is 2GB (ever since 2.0 I believe)
    http://office.microsoft.com/en-us/as...868081033.aspx
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    BTW - I note you are thinking about Access as a web BE. I haven't used access for the web (it would be hopelessly inadequate for my needs) and I would have reservations about doing so e.g.
    http://databases.aspfaq.com/database...ms-access.html

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Quote Originally Posted by pootle flump
    Nice extra info hammbakka but I'm afraid it is 2GB (ever since 2.0 I believe)
    http://office.microsoft.com/en-us/as...868081033.aspx
    Thank you for the correction, you and Micro§oft are right....

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    255 limit

    Note: The 255 concurrent users is if they are using the SAME database. With a little creativity like the routine below, you can easily have more than 255 concurrent users (and easily track who's using the db or not with the routine below - all you would need to do is tweak the parameters to the location of the database in the vbscript (one line) and set up a shortcut on the user's desktop to run the vbscript verses the mdb/mde itself). You could also get around some of the other limitations with some creativity.

    A little bit of object-type programming will also help. There are lots of ways to make MSAccess a great front-end for MSAccess tables/SQL Server tables, etc. But use SQL Server as the backend and I doubt you'll ever approach your file size limit. And most MSAccess mdb/mde's themselves don't get over 50 megabytes in size unless you've done some pretty wierd programming in the mdb/mde with a lot of inserted objects/reports/etc.. If you get an MSAccess mde which is over 100 meg in size, it might be time to split up some of the routines to 2 mde's (i.e. one for reporting, one for data entry).
    Attached Files Attached Files
    Last edited by pkstormy; 09-18-06 at 11:18.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  8. #8
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by pootle flump
    Nice extra info hammbakka but I'm afraid it is 2GB (ever since 2.0 I believe)
    http://office.microsoft.com/en-us/as...868081033.aspx
    Poots. NOPE. A97 is a 1 Gig limit. And I believe that A2K is also ... A2002 on up is 2 Gig definitely ...
    Back to Access ... ADO is not the way to go for speed ...

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Yep - I was a bit early on my version there. Had a google - 2GB on 2K+.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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