1 gig is the hard limit per .mdb. Prior to that limit, you may or may not have performance problems, depending on whether the size is due to large numbers of records, many objects, or just failure to compact. But you can really get almost as big as you want, since you could put, say, one or two large tables into a separate mdb, smaller tables into another mdb, etc. <br><br> As a side note, when you set the SQL property of saved queries, especially in loops, this can cause the db to grow very huge very fast, even though there may be few records and few objects--this is because Access stores every iteration of the SQL property as a saved querydef. A loop that iterates several thousand times will result in several thousand 'hidden' saved queries, which aren't cleared until compaction. I once had a db grow to 1 gig in about an hour (from about 40 meg) just off-loading data--I came back to my desk to see a "disk or network error" message.<br><br>Jim