I would like to make what is proving to be an impossible database.
I want a web database that is permission based.
I want it to be similar to a "contacts" database, but when a user logs in to see it, I want them to only be able to see their line. That is to say, when John Smith signs in, I only want him to see the line for the information relating to John Smith. Also, I do not want that user to be able to edit that information.
But, when I sign in, not only do I want to see everything, I want to be able to edit it, right there from the internet and have it save the changes to the database.
Can Access do this?
If Access can not do this, can anyone direct to a program or company that can?
Thank you.
P.S I Have both Access 2010 and Access 2007