• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

Frontpage multiple users on access database

I have a table thats going to include company name, unit #, history and possibly some other fields. I have it connected in frontpage 2002. How could I go about only allowing certain people to view certain information. Example, say I have a company called Company1. The table includes all different companies information. How can I allow company1 to only see results that pertain to Company1 in the table?
0
enochstek
Asked:
enochstek
1 Solution
 
rcmbCommented:
Is this an Intranet?

If yes, what I have done in the past is to create different directories with the files associated for company1 in one folder and company2 in another. Create forms with drop-down menus to allow the user to only select company1 and other information to query on in the company1 folder and do the same for company2. Now set permissions using NTFS on the folders to only company1 users or company2 users.

If no, then you need to do the same but instead of NTFS permissions you need to create logins and passwords to prevent access to the other's information.

RCMB
0
 
webwomanCommented:
Give them a login page. They enter a username/password you supply, it brings up only their info. Set a cookie on their machine, and check for the cookie on each page. No cookie, no access - you just redirect them to the login page. I do this for some things, it works fine.

If you need it to be VERY secure, you could do the directory/account route that rcmb supplies. However, if you don't have total access to the server to create accounts, that's not possible.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now