I want to set up a web page that can access a database I have written. I want to have different businesses accessing that database and making entries. However, I want each business to be only able to access their own data.

Can I do this by setting up different accounts for each business or do I need to have a separate database for each business.

Each business will not be loading too much data but each business cannot be allowed to see another firms data.

Take a look at the concept of Record Level Access. Search for that in the FM Forums here. That's the way to accomplish what you want to do.

Steven

Thanks Steven, I figured there had to be a way to do this.

If you're using Instant Web Publishing, record level access should work nicely.

If you're using Custom Web Publishing, then you can create a login system that holds their company ID and re-use that in every search they do to restrict them to only their own records.

I am usin CWP so will have to use a login script.

Thanks Webco. Have you a sample script I can amend to suit my purposes?