I need nothing fancy, just a simple website that Users can search and view records from my Access Database (currently I have about 10,000 records, but this will grow over time to about 500,000 records as I add more). I used ASPRUnnerPro (the free trial) to create a page,but it won't show me more than the first page of data records and I am unable to sort, etc. I keeps giving me an error message, something to the effect of "oops." Is this just because it a trial version?
How many records will I be able to put into my Access Table and still make it "searchable?" I only have 15 fields in my table, but there will eventually be alot more records going into it.
Is an Access DB good for this application?
I will also be needing Users to login prior to accessing the records.
How easy is it to set the website up to charge a one-time fee for unlimited use of the database?
Thanks for you consideration.