i have a Users Table in my MS Access database with around 35 fields. It would be populated with around 10,000 records. Can it still handle this amount of data? if i create a recordset and display all the registered users and search through it, will it still be A-OK? im concerned about load time. thanks in advance.

The last time I heard, an Access 2000 DB can be a maximum of 2 gigs, so I don't think it has anything to do with how many records it stores.

But then again...I could be wrong.

Your limit on Excel for records or lines is 65000 and odd. Access can store a lot more than that. I am unxure of the actual file limit. With that amount of records and fields, you may look at upgrading to SQL.

For load times, just limit your records per page and they should load fast enough.

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2