Best way to handle 1000's of user accounts?

[Kent Searight]

Hi all,

I was wondering what would be the best way to handle thousands of user accounts in a file. One aspect of my project requires the public to be able to create their own password-protected accounts at several kiosks where they can fill in and edit their demographic info.

I've set up user account creation via UI and script in other solutions, but I've never really given much thought to how to handle possibly 10's of thousands of accounts. Can anyone who's done anything similar to this offer me some insight? Would external authentication be preferable? Would it be preferable to control the accounts at the record level? The latter sounds risky.

Thanks in advance for any help offered.

[Kent Searight]

Nobody has ever dealt with anything like this before? :idunno:

[Martin Brändle]

I would try a web-based solution in your case.

[Steven H. Blackwell]

I doubt that External Servre Authentication will work here unless you create a method for users to create accounts in the Directory Service.

I did a demo at DEVCON a few years back before FMP 7 came outthat showed automatic Accoutn creation. I believe i had a couple of thousand Accounts then. All were internally authenticated.

Steven

[Triodes]

Create an extra table to contain users/passwords/etc... or even just add a couple of fields (don't know your setup). Have all users login automatically as "guest" or whichever level you want to give, and script to check the users against existing records in the tabel/fields you've just created. This way you're not affecting the accounts/privilleges, but are still registering all the users/passwords that log on along with their survey info.

Edited July 5, 2006 by Guest