This is general question only. How many number of records that Access can handle as a maximum records?
Or it only depend on size limit (4GB)???
It depends on the version of Access.
Access 97 had a total DB size limit of 1GB. The Max number of records would thus be substancially less than this.
I believe that this memory limit was increased to 2GB in Access 2K
If you use ADP files in Access (SQL Server/SQL Express) the max db size is 2 or 4 GB, depending on the version. But, the max number of records will be much less than this, as each record requires storing the data, plus overhead.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert