J John Vinson Mar 5, 2004 #2 Does anyone know if there is a limit as to how many records ACCESS will hold? Click to expand... 2 GByte in the entire .mdb file; no explicit limit on the number of records, though as a rule of themb you should start thinking about client-server if you're pushing 10,000,000 or so (though I know of bigger Access databases).
Does anyone know if there is a limit as to how many records ACCESS will hold? Click to expand... 2 GByte in the entire .mdb file; no explicit limit on the number of records, though as a rule of themb you should start thinking about client-server if you're pushing 10,000,000 or so (though I know of bigger Access databases).