hi guys,

anyone knows how large a database can hold its database?
is there a limit to how much a database can hold?

[Microsoft Access]

Snowydust

__________________
Snowydust

Try this link you should find the information you are looking for.

http://msdn.microsoft.com/library/de...l/acmsdeop.asp

Larry Asher

As long as i know for MS ACCESS in my implementation.
----------------------------------------------------------------
   MAX_RECORDS OPTIMAL ACCESS 7500 records per table
   HIGHER than that MS ACCESS give a low performance
   that's why MS ACCESS just usefull for standalone application
-------------------------------------------------------------------------
MS ACCESS has a problem with the Index records in a table or DB
that's why they PUT THE OPTION MENU --- COMPACT AND REPAIR tools for us.
This is to fix the index in your database, to avoid their bug's to show
-------------------------------------------------------------------------
To prove this, try to insert a records in a loops, for 8000 or higher NUM of Rec's
you might be got the BUGS_MSG from MS ACCESS
i have tried once and the results, terrible . . .( GENERATED )
----------------------------------------------------------------
that's all from me. Bye snowydust . . .