Dreaded Access...

[ryanrat]

Hey all -

I'm developing a pretty simple CF application where most of the changes to the database will be handled by 1 administration person. The only addition/change to the db that will be made by the end user will be a self registration page (username, pass, Name, address etc.) I may have anywhere from 50 users to 500 end users, depending on the popularity of the site. My question is, is it wise to use Access for the db in this manner, or should I not even attempt it?

 

[JHoarty]

Access will be just fine under the circumstances you described. I've seen Access backends stand up to much more than the traffic you anticipate. No worries! John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[geokor]

I've worked with Access backends upto around 20,000 records and several hundred simultaneous users and had no problems. I have heard, however, that once you get over somewhere around 30,000 records, Access can slow down during searches. Good luck.

 

[ryanrat]

Thank you so much for your posts! They have helped me tremendously!