we have about 20,000 test records that's in Excel. we would like to use asp with MS Access as the database to store our data. is there a maximum limit as to how much MS Access can hold? we would like to be able to search, sort, add, delete, and print report. It would be a web-base so that a customer can enter his/her own information onto a form, then submit it to us. Once it's in-house, each department will perform the different tests of the product send requested. can the above request be done in ASP and MS Access or do i need to start with SQL? thanks: confused:
More...