General discussion

Locked

Access Problem

By khall3 ·
Here's the scenario. I have created a Salesman Database where our Salesman can open the Database with no permissions except to open their own table and update their customer information. Example, Alan can login and only open the Alan table. All other tables cannot even be viewed. What I really would like would be a form that started up. Then Alan would be shown his table and he could start editing his information. So basically I would like a form that would open up and depending on the login bring up the appropriate table. Can anyone help here?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access Problem

by kees.valkenswaard In reply to Access Problem

Most versions of MS Access have the start up.. option under tools. There you can specify a form to be shown at start-up.
NOTE This is independent of reading writing rights but a handy possibility to start at a given point.
good luck

Collapse -

Access Problem

by khall3 In reply to Access Problem

I realize that you can make forms load up at the startup. But I guess what I am asking is, I have never developed a form to log users in and show them tables based on their login. Thanks for your help.

Collapse -

Access Problem

by Bristar In reply to Access Problem

You will probably need to read the login name to a variable and use the form with the variable name of the table.

Collapse -

Access Problem

by khall3 In reply to Access Problem

Poster rated this answer

Collapse -

Access Problem

by Bristar In reply to Access Problem

Perhaps I should expand a little more:

You remove all Access-level login capabilities. Then you setup a form as a customized login screen. When Alan logs in, you capture the login name to a variable, check it against the list of current users, and display the information you want him to see. You can hide all other areas by using an "[object].visible = false" command.

Alternately, you can use the name login name variable to open your tables. Just try something like this: "DoCmd.OpenTable strLogin" where strLogin is your login string name.

If you run proper error checking, this will work flawlessly for you.

Collapse -

Access Problem

by khall3 In reply to Access Problem

Poster rated this answer

Collapse -

Access Problem

by khall3 In reply to Access Problem

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums