Software

Ask something
Discussion Locked

Access Problem

0 helpful
7 replies

by khall3

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

7 replies

by kees.valkenswaard

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

by khall3

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.

by bristar

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

by bristar

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.

This discussion is closed to new replies.