Maximum Records for an Access DB

[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.

 

[Nikos Yannacopoulos]

Phil,

I'm sure the problem is not directly related to the number of records.
While Access 2000 has no specific record number limit (the limit is
total database filesize <= 2GB), I can assure you 10k is peanuts anyway;
one of my production databases (multiuser BE) currently has in excess of
600k records in a table, and I'm sure others could offer bigger numbers.
Speaking of size, you should somehow Compact and Repair regularly, not
just for size, but for database health as well.
Now, on the sorting issue, you should first look at whether specific
sorting is actually imposed in the report design, and do it if not. I've
heard many a time that sorting on the query that serves as the report
recordsource doesn't always come through (especially in larger reports,
which may well be indirectly connected with the number of records in the
table!).

HTH,
Nikos

 

[Guest]

Thank-you Nikos, you have confirmed what I suspected. I have in-herited this
DB thats been through a couple of hands with varying upgrades. There is a
compact and repair util included in the app for the local managers to be
running on a regular basis. Your theory on the sorting is something I too
have suspected....looks as though I'm about to roll up my sleeves and dive
into a pool of source code.....

Thanks again for the speedy reply.