MS Access Multiuser - multi user

Author

multi user

Herr Li

2006-01-20, 3:24 am

Dear friends,

I have a very simple access database:
It only has three column: sales person ID, invoice number, invoice amount
What I want to do is:
We have 5 sales person, and they have their own unique ID, and when they
open the database, they can use their own ID and password to open the
database file, and enter their own invoice number and the invoice amount.

Could anyone tell me how I can do this?

Thanks a lot in advance.

Li

Larry Linson

2006-01-20, 8:25 pm

"Herr Li" <gzlibobo@pub.guangzhou.gd.cn> wrote

> I have a very simple access database:
> It only has three column: sales person ID, invoice
> number, invoice amount
> What I want to do is:
> We have 5 sales person, and they have their own
> unique ID, and when they open the database, they
> can use their own ID and password to open the
> database file, and enter their own invoice number
> and the invoice amount.
>
> Could anyone tell me how I can do this?

What, specifically, did you want to know?

You can easily do this with Access, but it is not clear whether you want
each sales person to be able to see only their own invoices, or all, or what
you expect to do with the information once you have collected it. (It would,
clearly, make little sense to collect information that you don't plan to
use.)

You could use Access' user and group level security to enforce opening the
database with a password and user ID, if security is an issue. If it is just
a matter of identifying the record, you may not need to go to the effort of
implementing Access user and group level security.

If you are conversant in Access' programming language, Visual Basic for
Applications, you could also use the Windows login ID (information about
doing this can be found at http://www.mvps.org/access/api/api0008.htm).

Larry Linson
Microsoft Access MVP

Sponsored Links