What is the Max Nr of records an access DB can handle?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My MS Access 2000 DB (originally designed in Access 97 and converted) is
being use by a number of different sits and users. At the larger sites where
there is a large number ( > 10,000) of records the reports do not print out
in alphabetical order.
 
Hi Phil,

AFAIK there is no limit for recordsets itself. Depending on your OS
there would be a limit for the *.mdb´s file size.

I suppose your problem refers to the SQL query. Please post again in an
Access or SQL related NG, because this one is for Outlook.
 
Back
Top