Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Who knows the default seting

Status
Not open for further replies.

hu68

Technical User
Feb 19, 2002
30
CA
I'm new in Access,I'm not sure if there is default seting about table and database(eg:the max size of tabale or database....).if it has this kind of seting where I can find it ? can I modify it?
Since the records in our table grow fast, I think it maybe beyond the capability of the table and database someday.Could anyone tell me some information about it?Thanks for any clues!
 
In access 97 max database size is about 1 Gb.

In Access 2000 and 2002, max database size is about 2 Gb, but I believe the individual table size is still about 1 Gb.
 
BeanTree
Thank you for prompt reply
my database is Access2002,Could tell me where I can find this default setting and modify it?Thanks!
 
this is not changeable. It is the ultimate limitation of Access.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top