Hello,

I work with sales leads and use Access 97.  I have salesman that work from
the road.  I need them each to be able to view ONLY his records in forms and
reports and then make changes to their records and let me view the changes-
basically have live data.

Would this idea work?
1.) Create a main database with the main form that I enter leads in, and a
query, form, and report for each salesman.
2.) Create a seperate database for each salesman linking to their queries,
forms, and reports from my database.
3.) Set a different password for each database.
4.) Create a webpage with each of their names on it that are linked to each
of their databases.

Would I get live data?  Would this be secure enough?  Would this cause any
function problems? Any suggestions?

Thanks!